IF(AND(DATE(YEAR

Heath Sanders

Hi Team,

 

If(and( this MONTH/YEAR date matches the [Comms Due Date]2 MONTH/YEAR date then return 2% of [Current Month Sales]2 dollar value or nothing. (Text number cell) 

 

=IF(AND(DATE(YEAR([Comms Due Date]2), MONTH([Comms Due Date]2), ([Current Month Sales]2,*2,''-"))))

Shaine Greenwood

Hi Heath,

 

It looks like you're in need of a lot of formula building assistance. Our community is happy to answer when they can, but I wanted to point you to our consulting team just in case you don't a formula in the Community: https://www.smartsheet.com/custom-consulting 

 

I'd also recommend adding a tag or two to your discussions, as some of our community members have set up their accounts to get notified specifically when a discussion with x tag is created. (I've added tags to this discussion for you.)