Set value in a column based on two conditions

[Anonymous]

Hi, 

I have a formula that does not work properly. 

I added a new custom column and put this as the criteria. 

So I want the value in the column to be set to 1 if shortlist = 0 and duedate is 3days from now or less. But that does not work all the time. Do you see any obious errors here?

[Greg_Deckler · Accepted solution]

Can you provide an example of where you are seeing an undesirable result and what you would expect the result to be?

For example, for today of 3/3/2020 if you were to tell me that you wanted 2/28/2020 to have a 1 I would say use -4 instead of -3

[Anonymous]

hey @Greg_Deckler 

Thanks for answering. Yeah, I got the minus all wrong, I was looking at dates 3 days ago, but I should have been looking for dates IN three days. So I just removed the - sign and it worked 🙂

Thanks for your tip about the EARLIER command! 🙂