How to perform an IF statement for blank values

[kaylab]

 I am trying to put "Not Accessed" In the last column for the boxes that contain '-' but nothing works. I've tried numerous IF statements and len but nothing seems to work. It is tied with users first/last name and their emails if that helps. All i need is for LastViewDate to show 'Not Accessed' when there is a blank. 

[Zapparoli]

Hi Kaylab.

Those "-" are null values, you can treat them by using IsNull Function.

In your case: If(IsNull(Latest),'Not Accessed', Latest).

You can use this either on your table or directly into the Script.

-Zapparoli

[kaylab]

Thank you for your response but for some reason it is not working in either.

[MayilVahanan]

Hi

Can you try with Alt function like

Alt(Latest, 'Not Accessed')

[kaylab]

That's not working either unfortunately.

[MayilVahanan]

Hi

Are you implementing the suggestion in front end or back end?