Countifs but leaving blank spaces if criteria is not met.


I am trying to find a formula that would provide me with the correct total count of weekly items, but leave the cell empty of future weeks.

Here's the formula that I have used so far and it works but I provide me with 0s for future weeks. The intent is to leave those week blank.

=COUNTIFS({Weekly Snapshot 3 Range 1}, >=[Column2]@row, {Weekly Snapshot 3 Range 1}, <=[Column3]@row)

Any help work be appreciated.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!