Can I use conditional formatting in calendar view?

blamlamay

I am trying to color code line items in calendar view and I do not see conditional formatting in the calendar view. I have watched all the videos and it appears it should be there and I am not seeing it. Any suggestions?

Thanks,

Beth

Andrée Starå

Hi @blamlamay

I hope you're well and safe!

It's the Task Bar option.

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

blamlamay

Hello,

I was asking specifically in the Calendar. It isn't pulling from my sheet to the calendar.

Beth

Andrée Starå

@blamlamay

Not sure I follow!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

blamlamay

Screen Shot 2022-03-18 at 7.25.02 PM.png

I'd like to color code each of these items on the calendar view with conditional formatting. I watched a smartsheet video that stated that we should have a conditional formatting option on the calendar view but i do not see it.

Andrée Starå

@blamlamay

Then my previous answer was correct. In the Conditional Formatting, you'd set up a Rule, and to color the Calendar, you'd use the Task Bar color option.

More info:

https://help.smartsheet.com/articles/516441-changing-the-color-of-gantt-calendar-bars

https://help.smartsheet.com/articles/516359-conditional-formatting#createrules

Make sense?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Loren C

I dont think you can. i think you will need the calendar app to do this.