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
Check out the Formula Handbook template!