Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula help please (Simple if statement!)
Good afternoon, I am having trouble with an IF statement returning a date. It works fine if I ask it to display a text column instead of the date column so I know my formula is correct.
Basically I have added a column with a display on calendar or not, so a simple Yes or No drop down. If it is "Yes" display the Event Date, if "No" display blank.
=IF([Appear on Calendar ?]1 = "Yes", [Event Date]1, " ")
Can anyone help please? For some reason it doesnt like displaying the date!
Thankyou so much