Trying to increment a value by 1 each day, based on a specific status. - GOV

Each day that a row is in an 'In Progress" status, I want to increment a counter to determine the # of days in progress.

So far I have tried an automation that runs daily and filters based on the condition. But I am not finding a way to add 1 to the counter.

I have thought about doing a function but can't find a suitable solution. Any suggestions would be greatly appreciated?

Find more posts tagged with

Formulas

Automations

Accepted answers

All comments

RWinslowGov

Assuming you have a Start date on your row it would be: =if(Status@row = "In Progress", TODAY() - Start@row)

DeeDee_Thompson

Thanks for your suggestion. :) The issue is that the task can go in and out of an "In Progress" status multiple times and I would have to keep multiple start and end dates.

TVang

@DeeDee_Thompson, try the following…

Create Two Columns

• InProgress Date - to hold the date that status changed to "In Progress"
• InProgress Count - to count the number of days that status is "In Progress"

Column Formula
• [InProgress Count] = IFERROR(NETDAYS([InProgress Date]@row, TODAY()),"")

Automated Workflow
Configure an automated workflow to run at the end of the work day.
• CONDITIONAL PATH 1 - When status is "In Progress" AND [InProgess Date] is blank, record a date in [InProgress Date]
• PATH 2 - Clear [InProgress Date]

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.