Help displaying a value present in another column if both conditions are met.

Options

I've been trying to create a formula that will display the Remaining fifty percent when I meet two conditions. Set up to be billed has to be 50% and Live Date can't be blank. If both are true, then display the Amount due for Integration. I have tried to use If and If Contains to no avail.



Tags:

Best Answer

Answers

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @brad.harder

    This formula should do what you need,

    =IF(AND(ISDATE([Live date]@row), [Set up to be billed]@row = 0.5), [amount due for integration fee]@row / 2, "")

    Tested as below.

    Hope it helps

    Thanks

    Paul

  • brad.harder
    Options

    It worked, thank you!

    I modified the last part and removed the divide by 2. I essentially just needed it to display the the amount due for intergration fee again. For context, they need to pay 50% initial (integration) and the remainder once live.

    =IF(AND(ISDATE([Live Date]@row), [Set up to be billed]@row = 0.5), [Amount due for Integration Fee]@row, "")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!