Weighted Forecast - IF formula

I'm trying to put together a formula that will populate a weighted forecast only if the probability is 80%, 90% or 100%.

I was thinking a column formula using IF.

The formula does not get an #unparseable, but the result is just a blank cell. How would I get the formula to populate $298,240?

Best Answer

  • Samuel Mueller
    Samuel Mueller Overachievers
    Answer ✓

    @Adrienne Strong if this makes sense, change your formula to

    =if(probability@row >=0.8, [design or procurement fee]@row * probability@row, "")

    that way if probability is greater or equal to 80% it will multiple your $$ by the probability in the same row, otherwise it will return nothing (<80$)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!