Special formula help

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

Hi, 



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

Stuart

 

Smartsheet Query formula.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!