Here’s the original formula in Excel: =IF( INDEX(PayD_Work_Days, ROW()-3, YEAR(INDEX(Pay_Periods,1,J$1)) - YEAR(FY_Start)+1 ) = 0, 0, INDEX(PayD_T4Gross, ROW()-3, YEAR(INDEX(Pay_Periods,1,J$1)) - YEAR(FY_Start)+1) / INDEX(PayD_Work_Days, ROW() - 3, YEAR(INDEX(Pay_Period…

I used quite a few “no code/ low code” applications (like Notion, Airtable, Monday.com among others) and formula language in Coda is by far best implemented. Chaining feature is really great and general implementation makes it much easier to understand and write formulas. At least for me :smile: I…

Very great example, @cnr ! [image] cnr: Neither of these are simple, but you don’t have the slightest chance of understanding the first one and I’ll bet you can figure out what the second one does. Totally agree.

[image] Marko_Petrovic: If only now we could get option for a proper full sized window for writing formulas I’m hijacking my own thread to talk a bit about this idea. I think Coda has an opportunity to do more here than just allow large editing windows. They are uniquely positioned to comple…

@cnr Fully agree with you. That would be quite a big improvement for people that are actually building and maintaining docs. We are now planning to go back to all documents we made for our company and start documenting everything (I am not still sure how should we do this, but we will find some goo…

For starters, I would be happy if we could include remarks on our code. This could be in the form of function that doesn’t do anything other then holding our remarks or starting a line with a semicolon or any other character that is available. Even though coda remains pretty readable, as functions g…

Interesting comparison. If you used Excel tables, I wonder if you might get a similar formula as the Coda one since you can reference columns in an Excel table? I haven’t used this formula myself, but perhaps the new LET() function in Excel might add to the readability of the formula.

I was migrating from an Excel old document. So this is a real world formula that I had to parse. In this case, it’s much less about Excel’s current capability and much more about the millions of unreadable formulas that still do something useful even if no one knows what it is.

Adding the ability to write formula comments with some standard line prefix like // or # would be awesome - and seems like potentially a quick feature to implement.

I think there are more elegant ways to implement commenting than the way it has been done traditionally. We have a whole canvas to use, and colors and (literal) commenting features. Coda can be used for documenting so many things: how might we use it to also document itself?

Yea I agree having some sort of “tutorial” or “tooltip” features for docs would be great too.

Let's Mock Excel a Bit

Al_Chen_Coda April 14, 2021, 6:50pm 13

@cnr A step towards a better formula builder: [Launched] Formula building, now bigger and better

Topic		Replies	Views
Ability to make comments in formulas Product Feedback	22	1676	February 28, 2023
Excel to coda formulas	4	108	July 16, 2025
New member, baby steps	3	1505	March 2, 2026
Moving from Excel to Coda	3	1725	March 18, 2018
[Request] Complex Coda Docs — Mapping them out for sustainability and continuous development Requests and Gigs	23	6653	June 7, 2022

Let's Mock Excel a Bit

Related topics