Hello, I have a board where I would like to have a location column so that I can track assets via a map. However, I also need individual (street 1, street 2, City, State, Postal Code) columns for my workflow. Is there a formula or integration that can take a location and split it out to individual address columns or vice versa (take individual columns and put it in a location column)?
I would recommend looking into the General Caster app. It would allow you to perform a formula and cast a result to a column.
I’m thinking best option is to take the address columns and write a formula to cast the full address into the location column. Gen Caster is a pretty powerful add-on.