Deadline based on Priority dropdown menu

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?

Find more posts tagged with

Formulas

Services

Project Management

Comments

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), ""))

Sign in to join the conversation!

Quick Links

Trending discussions

Cell value for main or subworkflows.
I am trying to create a formula or workflow that changes a cell value to a value in another cell. I tried with workflow, but I can only assign a text or specific value from a drop down. But I want to assign a value from a specific cell. Formula would help, but this then needs to change depending if the cell is already…
Returning multiple results for a cell with multiple values
I have two sheets: one is a form collection table and the other is a reference table. One of the fields (Code) entered in the form collection table will determine who is responsible for the request submitted. The Code cell can have multiple values (separated by a comma and space). It is possible to have multiple people…
Multiple conditions for counting
Super-basic question regarding COUNTIFS. I'm trying to return a value that shows me a count of projects from a certain year, for a certain client. =COUNTIFS((Project Number:Project Number), Contains("2025", @cell ),(Client:Client), Contains("ADV", @cell )) But this comes up as unparseable. Where am I going wrong?