We often get feedback that formulas are the most intimidating part of spreadsheets. I find them tedious at best, and can never remember the correct order of arguments for a SUMIF vs SUMIFS. But for better or worse, they have stood the test of time.
We’ve wanted to find a way to simplify formulas for a while, but we could never really figure out something that was simpler, still compatible, and widely understood. While building thousands of templates for our gallery, we had a realization that most of the formulas we all write are just simple summaries, groupings, and cleanup functions. So instead of trying to kill this formulas, we decided to just put them a few clicks away, right where you’d expect.
Analyze data like you’re building a flow chart. Drop in a CSV or copy over a table. Quickly group data, filter and summarize tables, build fully linked workflows, and clean up messy tables. The best part is that it all outputs in just your regular everyday normal spreadsheet formula cells… not a pivot table! Edit the formulas further, add more analysis, or just format and export. Read more here.
Grouping, summing, or counting a dataset by some column is one of the most common things we found ourselves doing. Not even the fastest Excel keyboard wizards like my cofounder Jason can write a SUMIF this fast.
For whatever reason, removing duplicates in other spreadsheets is a one time action. Any time you add more data, you need to rerun it. We just built a de-duper directly into our sheet. It will always be linked up, de-dupe once and be done!
Want to only see debit card payments over $80? Create a new table with only those charges with a few clicks.
Need to capitalize something but have no idea what the formula is? Quickly cleanup messy data without needing to know.