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
Dawn
Comments
-
Dawn,
Β
Check if the column type is Date/Time or Date.
If Date/Time, that means the column is part of the sheet Dependencies.
The Date/Time columns linked to the Gantt chart and calendar can't have formulas because the system will override them based on other user input.
Β
Otherwise, you formula looks OK.
Β
Does your formula show up like this
Β
'=IF([Appear on Calendar ?]1 = "Yes", [Event Date]1,"")
Β
with the single quote ' symbol? That is the second clue that the formula won't be accepted.
Β
Craig
Β
-
Thank you Craig, I knew it was something simple - it's obvious now
Dawn -
It very often is, once you know the answer.Β
Β
Glad I can help.
Β
Craig