How can I set the default value for a column?

Setting a default value to a new row

Written by Mallika Ranjan Updated over a week ago

For new rows in my to-do list, I want the date column in my table to default to today's date and the status to default to "Not Started". Click on the column you want to apply the default to and choose Format Column. Then add your option in the Value for new rows field:

You can include a value like "Not Started" or choose Add formula and include something like =Today( ).

Some other formula examples:

Set the value to count of rows in table: =thisTable.Count()

Set the numeric value to the next number in sequence starting at 1: thisTable.NumberCol.Max(0) + 1