Formula to update status value

Steve Beshuk
Steve Beshuk โœญโœญ
edited 12/09/19 in Smartsheet Basics

Hi,

I would like to create a formula to update the value in the status field (it's a drop-down list). If the start date is in the future = "Not Started," if it's in the past = "In Progress,"ย if it's 100% Complete, then "Complete."

I've tried and get an unparseableย error.ย  Any help wouldย be appreciated!

· Share on FacebookShare on Twitter

Comments

  • J. Craig Williams
    J. Craig Williams โœญโœญโœญโœญโœญโœญ

    What formula did you try? (It helps to see what you column names are)

    What about Today (neither future or past)?

    Something like this will be the pattern

    =IF([% Complete]@row=1,"Complete",IF([Start Date]@row > TODAY(),"Not Started",ย "In Progress"))

    Note that Complete comes first so the date effect is ignored.

    Craig

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video