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
Check out the Formula Handbook template!