Column Names not being recognized in formulas

Options

Hi, I'm running into a problem with the column names not being recognized when typing in a formula. I am trying to count the number of users with access using the "yes" symbol and "Active" status using the following formula:

=COUNTIF([User Access]:[User Access], "yes", [Status:Status], "Active")

This formula should work but I keep getting an UNPARSABLE error and I noticed that when I type in the formula, it's not recognizing the column names and turning blue like it usually does. Any idea what could be wrong?

Thanks!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!