Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Set value in a column based on two conditions

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?

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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! 🙂