Help with formula

Hello! I have two columns in my smartsheet that I am trying to use in a formula. One is for RAG status and the other is summary task. I am trying to create a formula that shows me the RAG status for all items that do not have "Summary Task" checked. Here is what I have, but it is not giving me the proper result:


=COUNTIFS({RAG}, "Down", {Summary Task}, "0")


I think I am struggling with how to handle the check box. If it were checked, I know I would use "true.' I tried false and now 0, but neither is providing the right responses.


Thanks!!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!