Hi there,
Lets say I have four fields:
A
B
C
D
I would like to create a single formula field that could show which of the above fields are blank.
So, for example:
If only A is blank, the field should say “Field A is blank”
If A and B are blank, the field should say “Field A and B are blank”
And so on …
I have been able to create a formula that tracks whether all the fields are blank, but I am struggling to find a way to use the formula field to display which specific fields are blank.
If anyone has any advice, that would be much much appreciated!