How to show the return result with dash "-" instead of number 0!

[choiyuenkwong]

Hi everybody, I am doing a simple task of retrieving the number of table rows but the format of result need to be starting from "null" or "-" then 1, 2, 3 ...... etc. Refer to the attached drawing, Scenarion 2 is what I can achieve but not exactly what I need by Scenarion 1.  Please help and appreciate, thanks!

[pendean]

Forgive me, but why are any of those a FIELD formula in the first place?

Shouldn't the TABLE cell looking for that information be the FIELD formula to read that digit/number/- if the purpose is automation?

And by chance, are you using SSM (SheetSet manager) at all?