Deadline based on Priority dropdown menu

203jk

Hello all,

I am using SS to process work orders. People fill out a form which has a priority dropdown column with classifications such as urgent, semi urgent, can wait etc... I wanted to see if i could write a formula in the deadline column to calculate a date based on the priority picked. ie- if someone picks urgent, the deadline would calculate a date 3 days after the date the form was filled out, if they picked semi-urgent then it would calculated a week later. if they picked can wait it would put no date.... Is this possible? 

Marcus Odum

Yes this is feasible. You need to create a date type column. Assuming you are referring a dropdown column titled "Urgency" enter the following in the date type column:

=IF(Urgency1 = "Urgent", TODAY(3), IF(Urgency1 = "Semi-Urgent", TODAY(7), ""))

203jk

Thanks!

 

Adam J1555

This is an easy little formula... I'm trying to modify it slightly to create a deadline based WORKDAY, but can't get it to process. Rather than setting a deadline for 3 days, I need it to be 3 WORKDAYs.

Adam J1555

Found the err of my ways... Got the formula to work:

=IF(Urgency@row = "Urgent", WORKDAY([Date Submitted]@row, 1), IF(Urgency@row = "Routine", WORKDAY([Date Submitted]@row, 3), ""))