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!)

DawnM
DawnM ✭✭
edited 12/09/19 in Archived 2016 Posts

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

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 03/06/16

    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

    Β 

  • DawnM
    DawnM ✭✭
    edited 03/07/16

    Thank you Craig, I knew it was something simple - it's obvious now :)

    Dawn

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    It very often is, once you know the answer.Β Laughing

    Β 

    Glad I can help.

    Β 

    Craig

This discussion has been closed.