Probably easiest to use the following approach:
- Start with a default template in a Google Sheet
- Make a copy into another specified sheet
- Populate the data
Thinks to keep in mind:
- Text displays as
ERROR if it is provided to GS4 as a formula
googlesheets4::write_sheet() cannot write columns of multiple types (e.g. some cells text, others formulas) because the input data.frame is limited to one type
- Might be possible to write list columns but that seems like a big headache