Help with Formula

MClifton

I need help creating a formula within the Sheet Summary.

The formula should read:

The total number of rows where the Original Workflow Session date is past today AND the Review Status is set to Approved.

Thank you!

Ray Lindstrom

Hi @MClifton,

Try this!

=COUNTIFS([Original Workflow Session Date]:[Original Workflow Session Date], >TODAY(), [Review Status]:[Review Status], @cell = "Approved")

Hope this helps!

BRgds,

-Ray