After join two smartsheets files into one the formatting disappears.

I am using a join to get information from other smartsheet files; I activated the percentage icon and nothing happens and the other fields with regular numbers also lost the original format; if there is no directly solution, I was thinking if I can apply the TEXT formula from Excel, but I couldn't find the equivalent for smartsheet.

=TEXT( value , format text)

=TEXT( A3/100 , "#%" )


Can you please provide me this formula if exist and I can add it to my JOIN formula.


Have a Great Friday!!!


Neil R Sanchez.

Answers