How can I update this formula to exclude a column?

LaDawna Johnson

=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.

Paul Newcome

It looks like that's what your formula is currently set up to do.

You count them all and then you subtract those where {Post TSA} = 1 (checked).

Are all of the referenced columns in your source sheet multi-select dropdowns?

Andrée Starå

@lewis hamilton

Your solution is for Excel and not Smartsheet so that won't work, unfortunately.

Paul Newcome

It looks like that's what your formula is currently set up to do.

You count them all and then you subtract those where {Post TSA} = 1 (checked).

Are all of the referenced columns in your source sheet multi-select dropdowns?

LaDawna Johnson

@Paul Newcome - All of the reference columns are single select except the territory and one of the domain columns.

Thank you for your help.

Cheers,

LaDawna 😀

Paul Newcome

Are you able to provide a screenshot that shows where the formula is not working? It looks like your current formula should be working the way you expect it to.

LaDawna Johnson

I wasn't sure if it was excluding post day 1, but since you have confirmed that it is I can relay this to the team. So there will be no changes I need to make.

Thanks again @Paul Newcome

Paul Newcome

Happy to help. 👍️

If after testing it does not appear to be working properly, feel free to revisit this thread and we can try some troubleshooting/new formulas.