Hi all, in a spreadsheet you can drag from the bottom right corner of a cell to autofill cells above or below with numbers that continue on, is there a equivalent way to do this in Coda? Without the use of a formula as I’d like the contents to still be plain text and I don’t want to effect the enti…

Hi @Josh_Unwin - you could try using “Default Value” to do this. So everytime you add a row it is populated but you can overwrite it too [image]

This has been bugging me for something I was making so I did a small improvement on Mallika’s version. Using the RowIDs can work on new tables but can will random results if you have deleted rows before and doesn’t take into account your numbering pattern. Which is what I needed in my table. So aga…

I copy/paste from Gsheets! (is that cheating?) It automatically creates new rows. Also if you select multiple columns it populates all columns.

@Dalmo_Mendonca - cheating no way! All is fair in sheets and docs :wink: That said - it is feedback for our team so we can ensure you don’t have to go all over the place to do this.

@mallika Has this been added? I’ve found a lot of help threads addressing this but no solution so far! My particular situation was twofold: 1) making a month column (Jan-Dec) and having to select each one by hand, when I should be able to drag the top down or autofill in some way, and 2) using look…

the column formula Find(Column1, TableX.Column1) where Column1 is your display column and TableX is the table containing Column1 it results in a unique sequence number from 1 to N for each row where N is the number of rows in TableX. It works for inserts. It will renumber the rows if you delet…

Hi all, Is there any solution for this?? Am I still supposed to do this in Excel/sheets and copy it into my coda table? I need to be able to copy a specific number over specific ranges of cells. This is hella easy in excel and sheets. ???

Hi Christina, Welcome to Coda! Just a general comment: Coda works VERY different to what spreadsheets do. Some things that we do all the time in spreadsheets do not really make sense in the context of Coda. Another example you will run into, is the inability to simply reference a cell in the “prev…

I have different needs on different occasions since I’m building out a new way to organize a data set to make use of coda features, converting from google sheets that filled a slightly different purpose. I’d like to be able to create long sets of sequential numbers, and I also need to create sets o…

Hi Christina, I have created two examples in the doc below that can assist you in auto populating rows in a table. One example uses a counter to increment the value for each row, the second copies a static value a certain number of times into new rows. [image] Auto populating rows · Ra…

Is there a way to autofill numbers in cells like a sheet?

Teresa_de_Figueiredo February 23, 2024, 2:12pm 16

Hi all, sharing an update on this – Launched: Auto-fill rows in your data set with AI

Try it out and let us know if you have any feedback!

Topic		Replies	Views
Sequencial Copy of Numbers in Coda Doc	5	2031	August 13, 2019
Auto-populating rows Doc Show and Tell	0	585	February 16, 2023
Autofill cell when cell in different table is filled?	14	328	June 14, 2024
Launched: Auto-fill rows in your data set with AI News from Coda	20	2391	December 31, 2024
Add rows automatically from another table for more than one user Product Feedback	18	4653	March 8, 2023

Is there a way to autofill numbers in cells like a sheet?

Related topics