in Coda.io everything is a list

In Coda everything is a list

This blog is about some essentials in Coda I already used in various posts. However if you are new to Coda and you want to speed up your understanding, this might be of help.

• All information in a column can be seen as a list
• In case a table has 10 rows, than any column has 10 items in a list
• If one row is empty, we note IsBlank( ) it is still an item in this list
• Rows can contain one item (like the date of my birthday) or multiple items (like all the RDV dates for a manager as the outcome of a formula). In any spreadsheet, all cells can only contain one item, not so in Coda, you can have one item or multiples. One or Multiple, we call it an item. This might be confusing if you start using coda. An item in a list can thus contain one or more values.
• Every row represents an item and has a position in the list. We use Nth() to get the position in a list of an item. For example on row 3 we find item number 3 (whatever the real content of the item may be) and we note this as Nth(3).
• Since everything in a column is a list and we understand that every item in this list has a position, we can calculate using positions. We can for example look for every third position in a list, thus 1, 3, 6, 9 and so on.
• CurrentValue is an item in a list on a certain…