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")
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"?
-
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")
-
That was it! Thank you so much.
-
Happy to help. 👍️
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!