Hi all,
I am trying to change the type of the data in certain columns of my table, it the most dynamic way.
My table looks like this: (sorry I’m typing from the phone)
| Name | Cause | Date1 | Con1 | Date2 | Con2 |
| Joe | sport | 2020-03-12 | 15 | 2020-04-16 | 32 |
all the rows are similar. No patterns, nothing special, just records. The number of columns DateN and ConN is variable, generated through a dynamic workflow, that’s why I am looking for a dynamic solution.
Now, all the values are V_String, and I need a formula that ‘identifies’ the column (Contains should do the job) and replace/assign/edit the Type of the data in that column.
Specifically: DateN should have date format (yyyy-mm-did) and the ConN should be Double (with two decimals).
Do you have any idea how to do it with formulas? Or with any other tool?
Thank you all.
