I’m using the Smartsheet Calendar App with a connected sheet that includes two columns:
- Event Type (dropdown selected by users)
- Event Grouping (formula-driven, derived from Event Type and used for calendar color grouping)
The Event Grouping column uses a formula to automatically identify the company name based on keywords in the Event Type field (e.g., if Event Type is “Company A – Marketing Event,” the Event Grouping formula returns “Company A”).
In the Calendar App, Event Grouping is used for color grouping. However, when creating a new event through the calendar, the app requires the Event Grouping field to be visible and editable.
Since the Event Grouping field is intended to be formula-driven, I don’t want users to modify it.
Is it possible to either:
- Hide the Event Grouping field from the event creation form while still using it for color grouping?
- Make the field read-only within the Calendar App form?
My goal is to ensure grouping remains formula-controlled rather than user-determined.
