IF formula Help

Hannahsamd ✭✭
edited 07/12/23 in Formulas and Functions

I need help with creating an IF statement for this criteria

I need a 1 if the Amendment column is populated and the Effective date is in January, a 0 if false

I am doing this for every month but need help creating this first one. I am creating a report out of this so I can sum them and get a subtotal for how many Amendments were created in January


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!