Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

AND condition help

Topic Labels: Formulas
529 1
cancel
Showing results for 
Search instead for 
Did you mean: 
sariahdog
4 - Data Explorer
4 - Data Explorer

I have a simple base that shows transactions each month and allows me to track date of the transaction.

I want to add a formula field that will compare Entered date (year & month) to the current year and month:

 

IF(
  AND(
    IS_SAME({Entered},TODAY(),'year'),
    IS_SAME({Entered},TODAY(),'month'),1,0
      )
  )
 

 

 

This isn't returning any values in the formula field though. If I just use one of the IF statements for either year or month, it works fine. It's when I try using AND that returns nothing. Any suggestions?
1 Reply 1
zazadi
5 - Automation Enthusiast
5 - Automation Enthusiast

I think you have only a problem with your syntax. Try this:

IF(
  AND(
    IS_SAME({Entered},TODAY(),'year'),
    IS_SAME({Entered},TODAY(),'month')
      ),
1,
0
  )