Can anyone help with this formula?

carak
carak ✭✭
in Formulas and Functions

I'm using in a sheet summary and it keeps returning #unparsable.

=SUMIFS([% Complete], [Task Type], "contract award") / SUMIFS([Duration], [Task Type], "contract award")

I'm trying to calculate the total % Complete as a percentage of the total duration for a specific task type.

Thanks

Cara

· Share on FacebookShare on Twitter

Best Answer

  • bisaacs
    bisaacs ✭✭✭✭✭
    Answer ✓

    Hey @carak,

    If you're trying to have the formula search a whole column, you have to have the column range entered like this:

    [% Complete]:[% Complete], [Task Type]:[Task Type], Duration:Duration

    Hope this helps!

    If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!

    I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!

    · Share on FacebookShare on Twitter

Answers

  • bisaacs
    bisaacs ✭✭✭✭✭
    Answer ✓

    Hey @carak,

    If you're trying to have the formula search a whole column, you have to have the column range entered like this:

    [% Complete]:[% Complete], [Task Type]:[Task Type], Duration:Duration

    Hope this helps!

    If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!

    I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!

    · Share on FacebookShare on Twitter
  • carak
    carak ✭✭

    Thanks bisaacs, that worked :)

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!