Let’s say for new rows in my to-do list table, I want the date column to default to today's date and the status to default to "Not Started". To do this, click on the column you want to apply the default to and choose [Column type] options (in this example, we’re looking for Date options or Select list options, respectively).
Then add your option in the Value for new rows field:
You can include a value like "Not Started" or click the little f formula button (or the blue Add formula line) and write 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) + 1Set the date value to next day, starting today:
=thisTable.DateCol.Max(Today() - 1) + 1Set a person as a default value by using the user's email as default, or the
=User()formula (see below)