Skip to content
  • Try Smartsheet

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

    List of Same Project name with unique date.

    ✭✭
    in Formulas and Functions

    I have four column as show in table below columns. I have one text/number column two date and one duration.

    "I have nearly 500 projects in my database. Some of these projects share similar names, and among them, certain projects have distinct submission dates despite having the same name. I need to compile a list of project names where the submission dates are unique but the project names are the same. This list will help me calculate the average duration it takes for projects with identical names to get approved."

    Many thanks ! 😊

    Screenshot 2024-04-26 161536.png
    · Share on FacebookShare on Twitter

    Best Answer

    • ✭✭✭✭✭
      Answer ✓

      Hi there,

      The easiest way to do this would be a Smartsheet report. Use the following settings

      Sheet - Whatever the name of your sheet is

      Columns - Project name, submission date, approval date. duration

      Filter - None

      Group - Project name

      Summarize - Average of duration

      Sort - by submission date.

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭
      Answer ✓

      Hi there,

      The easiest way to do this would be a Smartsheet report. Use the following settings

      Sheet - Whatever the name of your sheet is

      Columns - Project name, submission date, approval date. duration

      Filter - None

      Group - Project name

      Summarize - Average of duration

      Sort - by submission date.

      · Share on FacebookShare on Twitter
    • ✭✭
      BullandKhmer

      Thanks, The report didn't come to my mind. Awesome 😎

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions