Set value of a โdateโ column?
I have a dropdown of selectable priority periods that inspectors can choose from:
Emergency, 1-3 days, 4-7 days, 30+ days.
In the app I have a โdue byโ Date column only available to admin. How can I set the โdue byโ column off of the selected priority period?
In other words, if the inspector selects โ1-3 days,โ the โdue byโ column should show Today plus 3 days.
Possible?..
You can use an AppFormula for that column SWITCH([Period],
โ1-3 daysโ, TODAY() + 3,
โ4-7 daysโ, TODAY() + 7,
โ30+ daysโ, TODAY() + 30)
@praveen In which column should I enter that formula?
The two columns are โPriorityโ and โDue By.โ
The column with the range-of-days for the inspectors is called โPriorityโ (Emergency, 1-3 days, etc.)
The admin column is called โDue By.โ The โDue Byโ column (which is a โdateโ column type) is the column where I want the magic to happen. Iโd like for the โDue Byโ column to show Todayโs date plus the selected range of days.
Thanks!
Youโd probably add this in the AppFormula for the Due By column
Thank you!!
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |