Reference Criteria-Result For Today Or 1 Day Ago

Tony Katt

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

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)

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)

Tony Katt

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

Excellent, Thanks

Paul Newcome

Happy to help. 👍️