How can I use a column other than the primary column in the calendar view?

I have a spreadsheet that has a client column and an employer column. The employer column is primary but when I look at the calendar, I want to see the client's name instead. Is that possible?

Answers

  • JamesB
    JamesB ✭✭✭✭✭✭
    edited 07/21/23

    @Connie Cochran To work around something similar to this, I created a secondary column and utilized that as my "primary", then in the true Primary column, I used the Join formula to bring in the data in the format I needed from the other columns and then hid my Primary column.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!