I have an IFS statement:
IFS(LOOKUP(USEREMAIL(), Users, Usr_Email, Time_View) = “This Pay Period”,
“THIS”,
LOOKUP(USEREMAIL(), Users, Usr_Email, Time_View) = “Last Pay Period”,
“LAST”
)
It checks the selection from an Enum value, “Time_View” but it always returns the opposite value.
“This Pay Period” returns “LAST”
and “Last Pay Period” returns “THIS”…
I have tried using a switch case instead and still had the same issue…
LinkedIn
Twitter
