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

Options
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
    Options

    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
    Options

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

    Dawn

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

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

     

    Glad I can help.

     

    Craig

This discussion has been closed.