SUMIFS not working (referencing another sheet)
Answers
-
Heya! I don't know of any changes, that's interesting.
I do know that values with leading 0s can sometimes be missed by COUNT or SUM formulas, which is fixed by using @cell = [content] instead of just [content].
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. Thanks! I feel like we tried the @cell reference in the other thread though and still had to use the VALUE function to convert to numbers instead of the [Column Name]@row + "" to convert to text. I can't remember. Ugh.
When I am writing my own formulas I ALWAYS use "@cell" references though, so I do tend to forget that not using them can sometimes cause issues.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 395 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!