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].
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!
Solved! Go to Solution.
Hi @vivian
Maybe check out Ifs or switch?
Hi @vivian
Maybe check out Ifs or switch?
Thanks so much Lynn!
I used switch() on my “initial value” for [Due Date]:
SWITCH(
[Priority],
“High”,[Record Date]+1,
“Low”,[Record Date]+5,
[Record Date]+3
)
@vivian
Good work.
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |