I am creating a form for inputting new tasks/ projects & I have a column named [Priority].
I have 3 priority options & would like to have an auto update on the column [Due Date].
- high = finish within 1 day
- Medium = finish within 3 days
- Low = finish within 5 days
My default setting on Data > Column is now “Medium” on [Priority] & “[Record Date]+3” on [Due Date].
But where should I insert the rules for the other 2 options?
Behavior > Actions & “Data: set the values of some columns in this row” on “Do this”?
or it is “Data Validity” on Data > Column?
P.S. Not sure if anyone ask the same question before but I can’t found an solution after going thru both community & YouTube. Thanks!