Solved: Virtual Column not Showing - Page 2

jfong12 · 08-31-2022 05:38 PM

Hi! I am using a virtual column (type - Yes/No) to show specific locations that meet two criteria: a department and a state. The end result I want is to show yes or no if it meets/doesn't meet based on the formula. I have the formula setup like this:

AND([Department]="Logistics",
OR([Work Location]='AL',
[Work Location]='AR',
[Work Location]='AZ',
[Work Location]='CA',
[Work Location]='FL',
[Work Location]='GA',
[Work Location]='IL'))

It works and shows in the 'Test' view. But when I add the column to my details sheet it doesn't show, however, it shows up when I use the form view, but nowhere else. I tried editing the formula and refreshing but no luck.

Any ideas on how to get the column to show up?

1minManager

Virtual columns don't show if the result is blank. To check this consider extending your formula by wrapping it with this IF() statement:

IF(
   ISBLANK(YOUR_EXIISTING_FORMULA),
   "No data found",
   YOUR_EXIISTING_FORMULA
)

Simon@1minManager.com

View solution in original post