Jeremy_D
Jeremy_D
-
Re: Formula Errors with Index match
You could use an ISBLANK formula to say that if the ID is blank then to produce a blank result. So it would look something like this: =IF(ISBLANK([*]@row), "", INDEX({Proj_Name}, MATCH([*]@…1 · -
Re: How to remove a zero after the first 2 letters in a string of text?
Hi Scott, to remove all zeros you can use a formula like this: =SUBSTITUTE([Column]@row, "0", "") Hope that works? :)1 ·
