Special formula help

Stuart.d ✭✭
edited 12/09/19 in Formulas and Functions


I'm hoping smartsheet community can help me with an automatic formula. 

We have a column called "Priority Deal" this is a symbol selection of the stars, where we rate a specific land opportunity (empty/one/two/three/four/five)

I'd like to create a formula when a specific star is selected, the column "Deadline Date" is automatically populated with a date based on the below critera, 

So for example :

Empty = No date

one Star = Five weeks from current date 

two stars = Four weeks from current date 

Three stars = Three weeks from current date 

Four stars = Two weeks from current date

Five starts = One week from current date 

Is this possible?  Extra columns can be added if it means we can get his working. 

I look forward to responses.

Kind Regards



Smartsheet Query formula.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!