How can I update this formula to exclude a column?
=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
-
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Your solution is for Excel and not Smartsheet so that won't work, unfortunately.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@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 😀
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!