Circular issue with countifs formula

Hi,

I have a circular issue with the formula below:

=COUNTIFS([Actual Go Live Date]:[Actual Go Live Date], [Actual Go Live Date]1, Hierarchy:Hierarchy, "2", [Guardian Client]:[Guardian Client], >0)

I tried this, same issue:

=COUNTIFS([Actual Go Live Date]:[Actual Go Live Date], [Actual Go Live Date]1, Hierarchy:Hierarchy, "2", [Guardian Client]:[Guardian Client], NOT(ISBLANK(@cell)))


I am trying to count the number of clients going live per month, for each row that is not blank.

Any idea what's going on?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!