How can I make my calendar reflect the color of a data selection?



I am making a calendar that will include multiple locations that will then be put on our company webpage so all global employees can see what is going on at any other location. People from different offices will be able to fill out the form and it will auto update on the webpage. I have a dropdown with the different locations that I want to color coordinate on the calendar that can be selected as forms are filled out

My question is: Is there a way to set up the sheet where people fill in a location and the calendar will automatically updated to reflect the color of that location? For example, when someone selects San Jose, it will be purple, when someone selects Albuquerque it will be yellow and so on...


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!