LastSamuraj - profile

LastSamuraj · Nov 08, 2023

Hello community,what do I wrong?  I have a field with #Numbers f.e. 80 or 80,1In another field I try to format this field to a url format, that means I would like to replace the , with an -.For this I use the Substitute formula:SUBSTITUTE({Numbers},...

LastSamuraj · Nov 09, 2023

Hi BillH, Thank you for your tip. It was almost right, your formula is just not quite correct. The characters & "" must be outside the {} in this case. So like here: SUBSTITUTE({Numbers} &"",",", "-")Now it works for me too and I no longer get Error!...

User Statistics

User Activity

Formula show #ERROR! when Substitute from a Number Field

Re: Formula show #ERROR! when Substitute from a Number Field