Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

  • 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)

  • 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!

Trending in Formulas and Functions