Column Names not being recognized in formulas


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?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!