Formula 30-days in future if priority = "high"

raven

Hi. I am absolutely no good at formulas! I'm hoping to have a due date 30 days in the future from when the row is added to the sheet, only if the project priority is "high". This will trigger a notification to the assigned PM. All other priority ratings should have a blank in this due date column (or an error, so long as it prevents the automatic notification from being sent).

I have a successful due date column for 6-mos for all projects (thanks to a post in this community!), but I can't figure out the right formula for only "high" priority projects.

Genevieve P.

Hi @raven

You can use an IF statement to check the Priority, then add on a specific number of days, like so;

=IF(Priority@row = "High", [Date Created]@row + 30, "")

This will add 30 days on to your "Date Created" cell. You can lock it to the column as a Column Formula, and then create a Time Based workflow based off of this date.

See:

• Use Formulas to Perform Calculations With Dates
• IF Function
• Set Formulas for All Rows with Column Formulas
• Create a Time-Based Automated Workflow

Cheers!

Genevieve

Genevieve P.

Hi @raven

You can use an IF statement to check the Priority, then add on a specific number of days, like so;

=IF(Priority@row = "High", [Date Created]@row + 30, "")

This will add 30 days on to your "Date Created" cell. You can lock it to the column as a Column Formula, and then create a Time Based workflow based off of this date.

See:

• Use Formulas to Perform Calculations With Dates
• IF Function
• Set Formulas for All Rows with Column Formulas
• Create a Time-Based Automated Workflow

Cheers!

Genevieve

raven

@Genevieve P. you are amazing as always, thank you!

Genevieve P.

No problem! 🙂