Archived 2016 Posts
Archived 2016 Posts
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.
COUNTIFS
I need to count the number of times the "Status" column = "Assigned to SCJ" and
the number of times a date appears in "NDA Signed" column in the same row.
Both criteria need to be met.
The "Status column is a drop down list.
The "NDA Signed" column is a date.
In the parent row, I added this calculation but it is not working. I'm sure it's wrong :-(
Can someone please help?
=COUNTIFS(CHILDREN(Status7), "Assigned to SCJ", [2016-NDA Signed (mm/dd/yy)]7), "1"
Comments
-
Hi Charita-- I'm so sorry nobody got back with you about this! Are you still having trouble with this formula? If so, feel free to share your sheet with me at Kennedy.Stomps@Smartsheet.com with Admin permissions and I'll be happy to help troubleshoot
-
I posted that inquiry over a month ago!
No worries, after a bit of research, I was able to figure it out.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.6K Get Help
- 472 Global Discussions
- 156 Industry Talk
- 511 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending Posts
- Advice is greatly appreciated. =SUMIFS({Alpine Master Range 3}, {Alpine Master Range 2}, "Not Awarded", CONTAINS({Alpine Master Range 1} "Chasse", @cell))
- My ultimate goal is to create an automation that will look at the total audits completed for the current month and if the number <10, a notification will be sent. In order to do that, I need the 'curr…
- Hello All, Thank you in advance for your help. I have a Red, Yellow, and Green symbols column in my grid view. In the sheet summary pane I want to have a summary column that provides the minimum value…
