Anyone know what the null value is in Smartsheet when using the search and replace function? I tried, "", <> and all the usual tricks- no go.
I want to search for a particular word in a string and replace it with.....nothing.
Jeremy - leaving the "Replace with" field blank and selecting Replace All will replace your string with "nothing".
Right you are. Never considered that angle....
Thnx for the support.
I have the same issue, and I don't understand Travis's solution. Can you please clarify how this finds a null value in a field and replaces it with something else?
