Solved: Conditional Format Rules formula - Highlight colou... - Page 2

helpdesk01 · 10-18-2024 12:17 AM

I’m try to use AppSheet to show google calendar's schedule acts as a display board showing in-front of the meeting room

I’ve added Google Calendar as a data source, and added a table from Google Calendar with column [Start] schedule start time and [End] schedule end time both in "DateTime" format.

What is the formula if I want to highlight the current schedule with different colour

Steve

Add a virtual column to the calendar table with an App formula like this:

IF(
  AND(
    (NOW() >= [Start]),
    (NOW() < [End])
  ),
  "Red",
  "Green"
)

View solution in original post

Conditional Format Rules formula - Highlight colour in the specific time range