Calendar App Add-on - New Event
Currently, I have the add new event function enabled for the calendar app. The calendar is pulling from a sheet which has a column where I am using a formula to format the event info in a way where it can be easily read by our team.
Is there currently a work around to "hide" the formula column from being accessible when adding a new event to the calendar, but still allowing the data to pull into the calendar app itself?
For existing events or line items that are created directly in the sheet, the user is no able to make edits to the locked formula column when viewing the event from the Calendar app view which is ideal. Looking for similar behavior when creating a new event from the calendar itself though.
Please see attachments
Thank you for support!