Coda Formulas are powerful ways to synthesize data in your docs and tables. Sometimes all it takes is the right formula to clean up a long list of inputs, uncover a crucial trend, or reformat your data to help tell a story. But we’ve learned that *finding the right formula* turns out to be more work than necessary in some cases!

Before, when you began entering a formula in Coda, we’d give you suggestions based on matches to the first letters in a formula. This works well for some formulas, but not othersーespecially ‘If,’ ‘Date’ and ‘Time.’

So we updated our formula search and suggestions to match text that might be in the middle of a formula. Now, typing “if” as you begin to write your formula will show you ‘If’ and ‘IfBlank’ as options *and* other if-logic formulas like ‘SumIf,’ ‘AverageIf.’ Matching letters are also bolded in the formula list to help clarify why they’re in the list.

Here’s another example using ‘Time.’

We hope this improvements help you explore more ways to put your data to work in Coda.

We’re always interested in your feedback! Feel free to comment on this post or reach out to our support team.