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?

1 Answer 1

=TEXT([text_column], "")
  • one tip regarding this answer: if you are using non-English regional settings use ; instead of , Commented Dec 11, 2020 at 12:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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