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.