How can I update this formula to exclude a column?

Options

=COUNTIFS({Territory}, HAS(@cell, $Territory2), {Domain Owner}, HAS(@cell, $[Tech Domain]2), {Status}, HAS(@cell, "Not Started")) - COUNTIFS({Territory}, HAS(@cell, $Territory2), {Domain Owner}, HAS(@cell, $[Tech Domain]2), {Status}, HAS(@cell, "Not Started"), {Post TSA}, 1).

I need to add to the formula (I am not good at formulas and someone on my team created this who no longer works on our team). I need to exclude the not started activities if "Post Day 1" box is selected. Our post day one activity field is check box.

Any help is greatly appreciated.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!