I have an automation counter that is working on 99% correctly. I cannot figure out why.
![Dakota](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
This formula is working everywhere except on Q2. this is a test for 2022. here is the formula.
=COUNTIFS({[Juan] Service Support KPI - [2022: Q2] Range 1}, [Tech Name:]@row, {[Juan] Service Support KPI - [2022: Q2] Range 2}, CONTAINS("COI - Request Change", @cell)) + COUNTIFS({[Kevin] Service Support KPI - [2022: Q2] Range 1}, [Tech Name:]@row, {[Kevin] Service Support KPI - [2022: Q2] Range 2}, CONTAINS("COI - Request Change", @cell)) + COUNTIFS({[Reba] Service Support KPI - [2022: Q2] Range 2}, [Tech Name:]@row, {[Reba] Service Support KPI - [2022: Q2] Range 3}, CONTAINS("COI - Request Change", @cell)) + COUNTIFS({[Seth] Service Support KPI - [2022: Q2] Range 1}, [Tech Name:]@row, {[Seth] Service Support KPI - [2022: Q2] Range 2}, CONTAINS("COI - Request Change", @cell))
Here is an example of it working correctly:
=COUNTIFS({[Juan] Service Support KPI - [2022: Q2] Range 1}, [Tech Name:]@row, {[Juan] Service Support KPI - [2022: Q2] Range 3}, CONTAINS("INVOICE - Customer Site Listing", @cell)) + COUNTIFS({[Kevin] Service Support KPI - [2022: Q2] Range 1}, [Tech Name:]@row, {[Kevin] Service Support KPI - [2022: Q2] Range 2}, CONTAINS("INVOICE - Customer Site Listing", @cell)) + COUNTIFS({[Reba] Service Support KPI - [2022: Q2] Range 2}, [Tech Name:]@row, {[Reba] Service Support KPI - [2022: Q2] Range 3}, CONTAINS("INVOICE - Customer Site Listing", @cell)) + COUNTIFS({[Seth] Service Support KPI - [2022: Q2] Range 1}, [Tech Name:]@row, {[Seth] Service Support KPI - [2022: Q2] Range 2}, CONTAINS("INVOICE - Customer Site Listing", @cell))
Best Answer
-
So it seems like smart sheets just wanted to me rewrite the formula.
Is there any reason why I would have to rewrite 7 out of 207 column formulas that previously worked ?
Answers
-
It's seems like i'm typing in @cell and smart sheets is defaulting the formula @row.
-
So it seems like smart sheets just wanted to me rewrite the formula.
Is there any reason why I would have to rewrite 7 out of 207 column formulas that previously worked ?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!