I would like to add on to this and count unique values (ie. repeated cells counted oncely once).

Options

=COUNTIFS({LCS}, $[Primary Column]@row, {Phase}, ISBLANK(@cell))

What can I add to do this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!