I have a calendar report that I need to add color coding to. I'm looking for a simple formula that says:If [Activity] = Build, make bar greenIf [Activity] = Go-Live, make bar redIf [Activity] = Support, make bar blueI'm not sure where to add this formula since I don't see a formula option for the report type calendar. I've tried adding the formula to a field I'm listing on the calendar but the color didn't change. I'm hoping there is an easy solution that I'm just not thinking of.Thanks!

I have never been able to successfully color the background. on a calendar but if you just have one field on caleder, then you can color the text. In these two separate examples I am making a concatenated field of the fields I want to show and then coloring the font (not the background) Example 1 var text NameDaysReason = List(" | ", [Common Name & Initial],ToText([# Days]),[Reason]); If([H S D]="H", "" & $NameDaysReason & "", $NameDaysReason) Example 2 var text TextBlock= List(" | ", "" & If([Start Time]<ToTimeOfDay ("10:00 am"),"0") & ToText([Start Time]) & "", [Physician : Location : Report Type], [Patient Name / Available]); If( Begins([Appointment Status],"No Show"),"", Begins([Appointment Status],"Cancel"),"", [Patient Name / Available]="Available","") & $TextBlock

Hi Mark. I'm having trouble making this work. I created a new field called ProjectActivity that pulls together the [Project] and [Activity] fields into one (which works using the List portion of my formula). When I try to color code the new field using example 1 that you provided, it errors. I copied directly from your answer but I'm guessing I'm updating something in my formula incorrectly. Any ideas? Thanks!List(" - ",[Project],[Activity]); If([Activity]="Build", "" & $ProjectActivity & "", $ProjectActivity)

Did you include the first line in the formula like this?var ProjectActivity = List(" - ",[Project],[Activity]);If([Activity]="Build", "" & $ProjectActivity & "", $ProjectActivity)

Yes, I have the var ProjectActivity = in the beginning of the formula. The error I receive is: A variable declaration must be followed by a type.

Can you add in the word text to the first line?var text ProjectActivity = ......

How do I add color coding to a calendar report based on text?

24 Replies

QuickBaseCoachD
Qrew Captain
10 years ago
I can only tell you an example what works. I suspect it has to do with the difference between your <div style> and my .
BenjaminLarrabe
Qrew Cadet
10 years ago
This didn't work for me. When I setup the Activity Label field, I kept getting a syntax error message. Apparently, you can't just put in the html, there has to be an If statement or some other type of expression.
QuickBaseCoachD
Qrew Captain
10 years ago
I suggest that you post a new question and reference this thread in your question. Please also post your current formula and what the error message says.
AZAZ
Qrew Member
8 years ago
I created this and it worked for me. All you have to do is create a new TEXT Formula field. Put this formula it there. Change the field names to your fields and it should work.

var text NameAbsenceHours = List(" | ", [Employee First Name] &" "& [Employee Last Name], [Absence],[Hours]);

If([Status]="Approved", "" & $NameAbsenceHours & "", "" & $NameAbsenceHours & "" )

Forum Discussion

How do I add color coding to a calendar report based on text?

24 Replies

Related Content

Calendar Reports not Loading

Color Code Date Field based on Formula

Color Coding based on field value

Color coding report based on Date Modified

Ongoing Schedual Calendar