Calculate a different initial value based on enum selection

Is there a way to calculate the initial value of a date column, based on which option the user chooses from an ENUM in the same table?

Column timeline: allows the user to choose
3 Months
1 Year
3 Years
5 Years

If they choose 3 months, I want the By When Column to default to the initial value of TODAY()+90
If they choose 1 Year, I want the By When Column to default to the initial value of TODAY()+365
etc.

Iโ€™m just thinking that I could do this using an action once the record is added. But is there anyway to do this with one action or will I need to run 4 separate actions, each one checking for a different value?

Solved Solved
0 4 844
1 ACCEPTED SOLUTION

Please try following expression in the initial value of โ€œBy whenโ€

IFS([Timeline]=โ€œ3 monthsโ€, TODAY()+90, [Timeline]=โ€œ1 Yearโ€, TODAY()+365, [Timeline]=โ€œ3 Yearsโ€, TODAY()+1095,[Timeline]=โ€œ5 Yearsโ€, TODAY()+ 1825)

View solution in original post

4 REPLIES 4
Top Labels in this Space