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
- Set the date value to next day, starting today: =thisTable.DateCol.Max(Today() - 1) + 1
- Set a person as a default value by using the user's email as default