Formula to update status value

Steve Beshuk

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!

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