Hopefully a pretty easy question that I need help with.....
I am newish to using formulas, and I am stuck. All I really need to do is have one column return as "true" based on the status. I am getting an error message. This will allow me to calculate my data in an Excel pivot table.
=IF(CONTAINS("COLUMN NAME",@row), 1, 0)
What am I missing?
Help Article Resources
Check out the Formula Handbook template!