Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Same Project, Different client (COUNT Formula)

Hi Guys,
Β
Can anyone help me do a formula for the smartsheet that I am working on (please see belw attached Pic). In the table, it indicates that there is a same project with different client, different Received and Sent Dates.
I would like to come up with a Count (or other possible) formula that will result to counting the Received dates as 3 only. Meaning, it will show that the same 3 Projects will be equivalent to 1 only. Same with the Date Sent!
Β
Thank you in advance for your kind reply ans solution.
Comments
-
Hi Jhay,
Β
You might need to add COUNTIF functions together in your formula:
Β
=COUNTIF([Project No.]:[Project No.], "P2001") +Β COUNTIF([Project No.]:[Project No.], "P2001a") +Β COUNTIF([Project No.]:[Project No.], "P2001b")
Β
Otherwise, consider lableing all of your project numbers the same, so you have three instances of P2001 that a single COUNTIF function can work with:
Β
=COUNTIF([Project No.]:[Project No.], "P2001")
Β
More information on our functions can be found in our Help Center:Β https://help.smartsheet.com/articles/775363-using-formulas
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives