I must be missing something fairly simple here.
I have this formula in regular column (Weekly Yardz), and a virtual column(Weekly Yards).
COUNT(SELECT(Jobs[ID], AND([Service] = "Weekly Yard", [Job Status] = "Incomplete", [Customer ID].[City] = [City], true)))
It is showing the number in the virtual column, but not the regular column. Idea why?
All Show? is set to True
Solved! Go to Solution.
An app formula in a normal (non-virtual) column is only (re-)computed when the row is updated, either when saved in a form, or when updated by an action.
User | Count |
---|---|
16 | |
9 | |
9 | |
7 | |
3 |