Formula to update status value

Steve Beshuk
edited 12/09/19 in Smartsheet Basics


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!


  • 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.