Conditional Checkin date color with Format Rules

AppSheet AppSheet Q&A
1

Hey,

I have a booking app, and it has a checkin date, now in slice view and Main view, I wish to show 3 different colors for checkin date, if the date is 10 days from today then it must be green color, if its 5 days then orange color and if its 3 days then it must be red color how can I do that?

regards

Rajiv

2

You will need 3 format rules , with expressions something like below. You may need minor adjustments depending on your precise requirements. For example 10 days away - does it mean 5 to 10 days or more than 10 days away? The below suggestion is for 5 to 10 days away for green color.

  1. Green color

AND([Checkin Date]> TODAY()+5 , [Checkin Date]<=TODAY()+10)

  1. Orange color

AND([Checkin Date]> TODAY()+3 , [Checkin Date]<=TODAY()+5)

  1. Red color

[Checkin Date] <=TODAY()+3

1 Like