Hi all, Do we have any text padding function that can convert (2018, 1) to 201801 and (2018, 12) to 201812?
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.
User | Count |
---|---|
25 | |
24 | |
24 | |
20 | |
16 |