1

I've got a simple list with 3 columns; Employee Name, Status, and a calculated field. Status column is a dropdown choice between "Active" & "Inactive"

Calc field formula is: =IF(Status="Active",[Employee Name],"")

When I first setup the calc field, it works perfectly. It shows as blank when Status is set to "inactive". However, if I then edit a Status from Active to Inactive, the calc field for that item shows a 0 instead of a blank/nothing.

If i go in and simply look at the calc field config, and hit OK without changing anything, all items that had a 0 now show a blank/nothing like they should. The calc field is set to "Single line of text".

How do I make the calc field show "" even after an item has been edited?

Improve this question
1
=TEXT([text_column], "")
Improve this answer
1
  • one tip regarding this answer: if you are using non-English regional settings use ; instead of , – Robert Wagenaar Dec 11 '20 at 12:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.