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
