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.

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.