Question on Metric Sheets and COUNTIFS formula
Hello!
I was working on a metric sheet and it was working perfectly but then all of a sudden my whole table went into error - not sure what I did!
Here is my formula:
=COUNTIFS({DPM Programme FY24 Workstream}, [Primary Column]@row, {DPM Programme FY24 Status}, [Column2]$2)
And here is my table:
Answers
-
=COUNTIFS( {DPM Programme FY24 Workstream}, [Primary Column]@row, {DPM Programme FY24 Status}, [Column2]@row)
Your second arguement shows $2 which is not a function used in smartsheet.
...
-
=COUNTIFS({DPM Programme FY24 Workstream}, [Primary Column]@row, {DPM Programme FY24 Status}, [Column2]@row)
@heyjay thank you - I have changed it this this previously but then get a #CIRCULAR REFERENCE error -not sure what that means as I have never come across it
-
@heyjay Yes. The $ is used to lock in a static cell reference and is perfectly valid within Smartsheet.
@SirJJ Double check your cross sheet references have not accidentally been adjusted. If one is referencing an entire column, the other should be referencing an entire column on the same sheet as the first.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!