Carrying Over EnumList Values from Last Row

AppSheet AppSheet Q&A
, , ,
1

I have an EnumList column comprised of to-do’s. I’d like the column to carry over the last values from that list when a new entry / row is being created.

For example, say the row for Monday’s to-do column has the following values:

  • Make doctor’s appointment
  • Reset schedule for house thermometer
  • Order groceries
  • Begin reading the new book

When creating the next row (Tuesday), those four values would be carried over and the user can remove some of the old values and add new ones, like below:

  • Order groceries
  • Begin reading the new book
  • Research the diet suggested for a blogpost

The three values immediately above would carry over to the the next new entry / row (Wednesday) and can be edited and added to and so forth.

Is there a way to do this?

2

Set the column’s Initial value property to:

[LOOKUP](https://support.google.com/appsheet/answer/10107410?hl=en&ref_topic=10104782)(
  [MAX](https://support.google.com/appsheet/answer/10107969)(
    Table[_ROWNUMBER]
  ), 
  "Table", 
  "_ROWNUMBER", 
  "To-Dos"
)
2 Likes
3

Solved my problem as well :grin:

Looks awkward to me but in the “Initial value” field it works in the “Suggested value” it doesen’t.

4

Likely, the Suggested value property requires an expression that returns a [list](AppSheet function list - AppSheet Help rather than a single value.

1 Like