FionaCarrQrew Trainee6 years agoColor coding calendar report for a checkbox fieldI have a calendar report that uses the following formula: Case(true,[Date of Event]=Today(), "#2f9d66", [Date of Event]<=Today(),"pink", [Date of Event]>=Today(),"#ffffb3",) This works well. I w...Show More
FionaCarrQrew Trainee6 years agoI took out the "future" event color coding and so just future events show blue if they require food (or else they are grey). That works. Thank you.
Related ContentReplacing Hard-Coded ParametersGoogle API QR Codes not working?Repeating calendar eventsCheckbox Formula - only pertinent recordsAutofill user field when a checkbox is checked
Recent DiscussionsFilter Monthly, Quarterly, Yearly from one Date fieldExtrapolating nuanced dataSolvedForms helpShare your feedback on the new Qrew DiscussionsGenerating QR Code with URL to record