Usersmail() Not Working

[Sirfyaad]

Hi

Usersmail() Functions is not working today 

[diogolupcosta]

there is no function such as USERSMAIL(). But if you refer to USEREMAIL(), it's working fine here

[Sirfyaad]

This time not working 

[Sirfyaad]

I have been using Expression for a long time but today it is not working properly.

IFS(
USEREMAIL() = "report@gmail.com",
IF(ISNOTBLANK([SCAN DATETIMES]), [SCAN DATETIMES], ""),
TRUE,
NOW()
)

I want that when the user is logged in from report@gmail.com and edits then there should be no entry in SCAN DATETIMES. 

[TeeSee1]

You should debug your expression element by element to see where it is failing.

What do you get if you create a VC with

1. USEREMAIL() = "report@gmail.com" to start with (EDITED)
2. USEREMAIL() = "report@gmail.com"
3. IF(ISNOTBLANK([SCAN DATETIMES]), [SCAN DATETIMES], "")
4. etc

[diogolupcosta]

Did you desactivated the 'require sign in' option? This function has a direct relationship with this option

[Sirfyaad]

No

[baba_sawane]

Hi diogo ! Can you elaborate ? 

I don't see how it is linked. EDIT : I mean, I don't see why it would affect negatively this particular use 

@Sirfyaad can you test your formula and see the app response to your useremail() condition ? Wether it says true/false (for the test, replace the email with your appsheet admin email).