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.

IF(AND(DATE(YEAR

Heath Sanders
edited 12/09/19 in Archived 2017 Posts

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,''-"))))

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee
    edited 02/21/17

    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.)

This discussion has been closed.