As you use Coda have you found things that were hard to find but easy to use once you knew it existed and figured out how to use it? Would love you hear of these in reply below. I have a few of my favorites below - I’ll keep adding to this list from the replies :slight_smile:

Using a formula to generate the visual row numbers (not RowID). There is a Find() variant that works for many of my cases, but it was not easy to locate. It was extra confusing (and still can be) since the numbers appear left of the rows (i.e. it seems like something that there is a formula for).

Thanks for the suggestions so far - I have added them to the doc.\ @GJ_Roelofs - Once I have the list I will pass it onto our product team to make in product improvements and we can also work on expanding these concepts and providing link and help for them. @Juan_Luis_Chulilla - good suggestion. F…

Ah, also that special care needs to be paid to whether it’s a value, or a list with a single value. in formulas (using .First() where appropriate) in formula columns with Lookup table type (properly switching the “Allow multiple values” on or off) More on that: Here’s a riddle for the community

That is a tricky one. We need a whole section dedicated to debugging and helping with this!

For me it’s understanding how to use formulas for something I can describe in words but am unsure how to actualize in the Formula logic. For instance, if there’s a value in a cell, then do X. I found the documentation on the Formulas a little dense (I’m not an engineer) so turning to Community and H…

Added @Ian_Nicholson - even I forget about that one now and then!

Hi @mallika , Instead of getting a copy from another users doc, That you can copy content from a “view only” doc and place it in a doc you are the owner of. Automatically you will be able to see all formulas used! Important: if the content you copy has “related tables”, “controls” and "formulas"o…

That you can see the changelog / history of a row, courtesy of Al_Chen_Coda: [image]

Oh! Not hard to find, but very counterintuitive. Say, I want to get a cell value from the first row of a table. Following the top-down logic, I’d first select the table, then the row, then the cell, i.e. write the formula like this: [Table name].First().[Column name] But this won’t work! The cor…

😬 What was hard for you to discover in Coda?

Ian_Nicholson September 5, 2019, 8:59pm 12

“Named Parameters”. See this thread.

1 Like

Best way to omit optional parameters in formulas?

Topic		Replies	Views
Why won't the Lookup formula work for me?	30	3835	August 16, 2021
Lookup data from another doc	21	3236	February 1, 2021
Launched: Simpler table setup News from Coda	18	2983	October 19, 2019
Feedback requested: How would you build reverse lookups in Coda?	50	6676	March 9, 2023
Realistic number of rows in a table Tips and Hacks	37	11120	April 4, 2024

😬 What was hard for you to discover in Coda?

Related topics