How to assign static Due Date based on IF function

From the table example below. When a specific value is chosen from the "Progress" dropdown column I want Due Date to have a static date assigned.

Currently I have the following but every day the Due Date is updated due to TODAY function I used. Any recommendations?

IF(Progress@row = "Waiting on Sales", TODAY(5), IF(Progress@row = "Waiting on Pricing", TODAY(5)..................

Find more posts tagged with

Accepted answers

All comments

JamesB

@otavilog

I use a workflow to set a date on the row when a specific cell in that row changes. This will keep the date static until the status changes on the cell in that row again. You will need a helper column to use the plus 5 function.

Example:

Static Date - Use automation to set this date.

Due Date =[Static Date]@row+5

otavilog

@JamesB got it to work. Thank you so much.

JamesB

Your Welcome.

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.