What am I doing wrong in this sheet summary?

I am trying to do a sheet summary formula to get the percent of tasked closed assuming Project Name is "RPA Project"

Please see formula:

=IF([Project Name]:[Project Name] = "RPA Project", (Closed# / [Count of Status]#), "")

The Closed # and Count of Status are also sheet summaries Below are their formulas:

=COUNTIF(Status:Status, "Closed")

=COUNT(Status:Status)

Tags:

Best Answer

Answers

  • Chance Marshall
    Answer ✓

    AI helped me figure this out but I don't know how to delete the question

    =COUNTIFS([Project Name]:[Project Name], "RPA Project", Status:Status, "Closed") / COUNT(Status:Status)

  • Georgie
    Georgie Employee

    Hey @Chance Marshall,

    I'm glad you got this resolved! Thank you for posting your solution - this will help other members!

    For future reference, to delete a post, you can click the Flag icon at the bottom of the post and select Report, then select the Delete Post option and add a note as to why you want to delete it, and we can action it on the backend.

    Cheers,

    Georgie

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • Try this formula instead:

    =COUNTIFS([Project Name]:[Project Name], "RPA Project", Status:Status, "Closed") / COUNTIFS([Project Name]:[Project Name], "RPA Project")

    This way, it’ll count tasks for "RPA Project" correctly and give the right result.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!