Well, if each user gets their own task (submitting a form/add button), then we’re back to each user on its own row which negates the necessity of user specific columns, I think…right @Mark?
However, I think you could do this…instead of the task column residing in the sheet, create a text column that’s user specific. Then, submit a form that adds a new task to that column. So…still one task per person per row. The benefit to this (I think) is that:
- It might not count against your row quota
- Zero Lag
- No formulas/relations/lookups needed.
Let me test!