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! Go to Solution.
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
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?
User | Count |
---|---|
18 | |
11 | |
7 | |
4 | |
3 |