Calculating a date in the future
My use case:
I receive reports that need to have an SLA tracked. From the date I receive the report, I need to calculate the due date. If a report has a severity of Critical I need to calculate the report date +60 days, if High, the report date +90 days.
I have a severity column with CRITICAL, HIGH, MEDIUM & LOW, I want to calculate the SLA due date based on the date in the [Report Received] column, which is a date, and have the due date automatically calculate.
Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!