List of Same Project name with unique date.
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 ! 😊
Best 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.
Answers
-
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.
-
Thanks, The report didn't come to my mind. Awesome 😎
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!