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.


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


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