Reference Criteria-Result For Today Or 1 Day Ago

Smartsheet Community:

Can Someone Help Me Modify My Existing Formula? I am Trying To Add to My Formula to Look For Anything Done or in UAT Today Or The Previous Day, excluding Weekends. Here is My Current Formula:

=COUNTIFS({Jira Status}, OR(@cell = "Done", @cell = "UAT"), {Assignee}, "Isha", {Resolve Date}, TODAY())

Thanks

Find more posts tagged with

Accepted answers

Paul Newcome

You would use another OR function for the date criteria similar to how you used the OR function for your status criteria. The first argument in the new OR function would be for TODAY() as you already have and the next argument would be a WORKDAY function

WORKDAY(TODAY(), -1)

All comments

Paul Newcome

WORKDAY(TODAY(), -1)

Tony Katt

https://community.smartsheet.com/discussion/comment/408967#Comment_408967

Excellent, Thanks

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.