I have a view which I want to add a column which will show if a date has been entered in a field on my form but instead of the date being shown in the view I would just like the column to display either"yes" if the date is filled in or “no” if not.
Thanks
Subject: view column yes or no if date entered
It is straight. Add the following field in the column formula :
@If(@Text(YourDateField)=“”;“No”;“Yes”)
Dhana
Hi,
@If(@Text(FIELDNAME)=“”;“No”;“Yes”)
Bye
Hynek
Thanks Guys Worked Great.