I am looking to format a number on the canvas : e.g 1000 to 1,000 or 1000 to $1,000.
It seems to work if the number is pulled from a table - it retains the format applied on the table.
Also, how current is the formula list in the help column? I couldn’t find the “FormatPercent” formula there. I found it by browsing the template gallery and found someone using it. Perhaps there is one for the number/currency formats I am looking for.