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

(Ivan Oboth) #1

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

(Aleksi Alkio) #2

You can do that with SUBSTITUTE and IF expressions

(Praveen Seshadri (AppSheet)) #3

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.