Thank you. Your workaround is valid, but unfortunately it won’t work for our scenario.
So, basically this is the use case I’m referring to:
We have a sheet (let’s call it Source sheet) where we sum up some information from various sources and present it as a general dashboard to our stakeholders. In order not to allow other people to access or view everything we have in source spreadsheet (other sheets, etc), we have created a destination sheet and synced it with Sheetgo, which looks exactly the same as the source one (thanks, Sheetgo )
The goal is to keep the layout exactly the same as on the source side, without adding new sheets with formulas referencing fields that might not exist in the future (we can easily remove the whole destination sheet and run Sheetgo sync again in case of some formatting error, or any significant change on the source side, etc, but then the concatenation formula will stop working and we need to address it each time we do that.)
So, if we import everything to destination sheet, and then create another one just to concatenate links, we can’t put back the links in the sheet as it would create a loop (concatenate A and B and put the result back in A). This also means that we would need to make changes on the source sheet, as we don’t have 2 fields for the hyperlink, but only 1.
I hope I was able to explain in more detail.