Hide field if formula not empty
I have a formula field that is:
"
" + 'First Name' + " " + 'Last Name'
I want to hide the 'first name' and 'last name' fields if the formula returns a result. If it doesn't return a result, I want to hide the formula and instead show the 'first name' and 'last name' field
Just having some trouble figuring out the formula to do so
2 replies
-
You can use an if-then-else condition in your Formula field to return your concatenated string if the condition is true or return something like "Hidden" if the condition is false (you can use any string you want, but you might as well use something that self-documents what's going on).
Then, in "Display field only, if:" for the 'First Name' and 'Last Name' fields you set the condition to YourFormulaField = "Hidden". In the Formula field "Display field only, if:" you would set the condition to YourFormulaField != "Hidden".
-
Thanks Sean!
Had a feeling it was something like that, haha
Content aside
- 4 yrs agoLast active
- 2Replies
- 1507Views