Why can't I use this If statment in my Sheet Summary

Malachilee

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

Paul Newcome

Try this instead...

=IF(CONTAINS("Red", [Enough To Build]:[Enough To Build]), "No", "Yes")

red1998

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.

Paul Newcome

Exactly how are you wanting this to work/evaluate your sheet data? If there are any red, then "No", otherwise "Yes"?

Malachilee

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.

Paul Newcome

Try this instead...

=IF(CONTAINS("Red", [Enough To Build]:[Enough To Build]), "No", "Yes")

Malachilee

That was it! Thank you so much.

Paul Newcome

Happy to help. 👍️

Malachilee

Paul,

So, is the @row only for formulas on the sheet?

Paul Newcome

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.