Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Combine 2 IF formulas

Samad
Samad
edited 12/09/19 in Archived 2017 Posts

Hi,

Can someone help me with combining these 2 formulas? 

 

=IF(MONTH([Date Raised]12) = MONTH([Date Raised]1), "Yes", "No")

and

=IF(YEAR([Date Raised]12) = YEAR([Date Raised]1), "Yes", "No")

 

Regards,

 

Samad

Tags:

Comments

  • Adam Overton
    Adam Overton Employee

    If you want both to be true, you can use the AND() function.

    =IF(AND(MONTH([Date Raised]12) = MONTH([Date Raised]1),YEAR([Date Raised]12) = YEAR([Date Raised]1)), "Yes", "No")

    Formatted another way:

    =IF(

               AND(

                           MONTH([Date Raised]12) = MONTH([Date Raised]1),

                           YEAR([Date Raised]12) = YEAR([Date Raised]1)

                       ),

             "Yes", "No"

         )

     

This discussion has been closed.

Categories