Formula 30-days in future if priority = "high"
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.
Help Article Resources
Check out the Formula Handbook template!