Select YES if result of date 1column + date 2 column are equal, select no if not

I am trying to get an auto select of a Yes/No result. I am comparing one date and if the second date is within 30 days of date 1, select the yes box, if not, select the no box. 

Currently I have date 1 in one row, date 2 in the next and a virtual row that calculate 30 days after date 1. third row I have as an ENUM with yes and no options. 

Hope the question makes sense, I am new at this app sheet stuff, please be gentle.

Thanks in advance

Solved Solved
0 6 148
2 ACCEPTED SOLUTIONS

Don't worry, there is no stupid question as they say.

The virtual column (because virtual rows doesn't exist) is not needed.

Your enum could be a Y/N Column also.

Anyway, the expression would be:

[Date2]<=([Date1]+30)

 This will be true if Date2 is minor than Date1 plus 30 days.

PS: If you wanted this to be on the "next month" there is an expression for that

View solution in original post

Much appreciated, I am using the Virtual Column as a visual result in the app. But if I can avoid having to make a user actually select a box, and have it already selected by the data already supplied earlier all the better, right?

View solution in original post

6 REPLIES 6
Top Labels in this Space