30天公式在未来如果优先级= "高"

raven · 03/28/22

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 ifthe 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. · 03/29/22

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:

Cheers!

Genevieve

Genevieve P. · 03/29/22

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:

Cheers!

Genevieve

raven · 03/29/22

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

Genevieve P. · 03/29/22

No problem!

30天公式在未来如果优先级= "高"

Best Answer

Answers

Help Article Resources

Categories