A subtraction

Options

I am getting an error message #ParSEABLE with the formula below, the values are coming from the below link as you can see in the second snapshot


Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Shannon Lacerda

    It looks like you need to separate SUMIF statements, then minus one from the other.

    For example:

    =SUMIF(formula) - SUMIF(formula)


    Try this:

    =SUMIF({Actual Billing Job}, [Job/ Opp#]@row, {Actual Billing (Total Billings) Jan}) - SUMIF({Forecasted Billing(Cashflow) Job}, [Job/ Opp#]@row, {Forecasted Billing(Cashflow) Jan})


    Let me know if this works for you!

    Cheers,

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!