Omid-M22

Extract_sum_of_Criteria= LAMBDA([Criteria column], [numerical column],
    IF(
        ISODD(
            SEQUENCE(
                COUNTA(
                    UNIQUE(
                        [Criteria column]
                    )
                ),
                2

Omid-M22

Month_of_Hijri_Date=LAMBDA([Hijri date],
    SWITCH(
        --MID(
            [Hijri date],
            FIND("/", [Hijri date]) + 1,
            FIND("/", [Hijri date], FIND("/", [Hijri date]) + 1) - FIND("/", [Hijri date]) - 1
        ),
        1,"فروردین",
        2,"اردیبهشت",
        3,"خرداد",

Omid-M22

FindX=LAMBDA([find text], [within-text], [r th repeat],
    IF(
        [r th repeat] = 1,
        FIND([find text], [within-text]),
        FIND([find text], [within-text]) + findx([find text], MID([within-text], FIND([find text], [within-text]) + 1, 100), [r th repeat] - 1)
    )
)

Omid-M22

ReverseText=LAMBDA([text],
    IF(LEN([text]) = 1, [text], RIGHT([text]) & reversetext(LEFT([text], LEN([text]) - 1)))
)