Calculating a date in the future

Edward Townsend

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.

Mark Cronk

Hi @Edward Townsend ,

In your [Severity Due Date] column, try:

IF([Severity]@row = "Critical", [report received]+60, IF([Severity]@row="High", [report received]+90, IF([Date received]@row="Medium", [report received]@row+ XXX, [report received]@row+XXX)))

You'll need to adjust the XXXs for the days required if medium or low.

Work?

Mark

Mark Cronk

Hi @Edward Townsend ,

In your [Severity Due Date] column, try:

IF([Severity]@row = "Critical", [report received]+60, IF([Severity]@row="High", [report received]+90, IF([Date received]@row="Medium", [report received]@row+ XXX, [report received]@row+XXX)))

You'll need to adjust the XXXs for the days required if medium or low.

Work?

Mark

Edward Townsend

Thanks Mark! I needed to add @ row to the [report received], but otherwise worked like a charm!

Mark Cronk

Excellent. Happy to help. Thanks for using the Community.

Mark