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.