I'm trying to create a CONCATENATE formula to create the following:
[{"record_id":"0","from_week":"04\/08\/2024","to_week":"06\/17\/2024"}]
In which the day, month and year:
04
08
2024
06
17
2024
would be pulled and concatenated from other cells. The issue I'm running into is that I have to replace the quote marks with CHAR(34) and it seems like the square [] brackets and curly {} brackets are also not accepted as concatenatable characters. Already the number of CHAR(34) needed seems a bit extreme.