Hi all, Do we have any text padding function ...

Ivan_Oboth
Participant II

Hi all, Do we have any text padding function that can convert (2018, 1) to 201801 and (2018, 12) to 201812?

0 2 356
2 REPLIES 2

You can do that with SUBSTITUTE and IF expressions

If possible, try to do some of this text re-formatting stuff in a spreadsheet formula โ€” seems like you are getting data in one format and you want it converted before you use it in AppSheet.

Top Labels in this Space