Hi all, Do we have any text padding function that can convert (2018, 1) to 201801 and (2018, 12) to 201812?
Ivan_Oboth (Ivan Oboth) #1
Aleksi_Alkio (Aleksi Alkio) #2
You can do that with SUBSTITUTE and IF expressions
praveen (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.