Why can't I use this If statment in my Sheet Summary
I would like to create a Metric Widget that will check and see if there are enough parts in an assembly to build that assembly.
Thank you
Best Answer
-
Try this instead...
=IF(CONTAINS("Red", [Enough To Build]:[Enough To Build]), "No", "Yes")
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
-
I believe the issue is because this is a sheet summary formula. It can summarize values in a column, but it is meant for the entire sheet and not individual rows. This IF statement would be useful as a column formula.
-
Exactly how are you wanting this to work/evaluate your sheet data? If there are any red, then "No", otherwise "Yes"?
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!
-
Yes, I'd like to have a quick reference on my dashboard if there are enough components on this sheet to complete the build. The sheet is my Bill of Materials.
-
Try this instead...
=IF(CONTAINS("Red", [Enough To Build]:[Enough To Build]), "No", "Yes")
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!
-
That was it! Thank you so much.
-
Happy to help. 👍️
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,
So, is the @row only for formulas on the sheet?
-
That is correct. The @row tells the formula to evaluate the column listed on the row that the formula is on. Sheet Summary fields are not rows.
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
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!