Hey all, thanks for the help in advance.

I want to maintain a waiting list in Airtable and can’t figure out how.

I have a client list with a single-select: “active” and “waiting” are the two relevant options here. I’d like each client with the “waiting” option selected to be assigned a number, each one integer larger than the last. Then I could use that number in formulas to estimate the waiting time for each person given their spot on the waiting list.

If I use the autonumber option I can’t exclude “active” clients, so the waiting list formula would skip numbers. For example,

John - active - 1 (shouldn’t have a number, but autonumber gives him one, anyway)

Mary - waiting - 2 (should be number 1 on the waiting list)

Frodo - active - 3 (shouldn’t have a number)

Sam - waiting - 4 (should be number 2 on the waiting list)

Does anybody know of a workaround for this, such that my list would read like this?

John - active - blank

Mary - waiting - 1

Frodo - active - blank

Sam - waiting - 2