Pre-Populating A Status for Calendar Events

Here is my guess…when you pre-populate, how are you doing it? An array formula?

When you make a new item in your calendar and save it, where does it save? Does it save way at the bottom below all the pre-populated fields?

Because you have pre-populated it as you have, it’s seeing all those rows as filled already and making a new item far at the bottom.

Would be helpful if you linked your sheet instead of a screenshot.

and did you see this thread?

2 Likes