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())


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!