I'd like to see an example to solve a similar problem
I'm trying to summarize the monthly activity of a sales person. I have the data sheet which has each person in a column, a parent row of the month, and child rows for each new week. What is a formula that I could utilize to summarize the information by sales person by month?
I've attached screen shots of the sheets I'm referencing. The first sheet is the data sheet.
This sheet is where I'm trying to summarize.
Yes, I can create a formula that references the specific cell, but I'd like to create a summary sheet formula similar to an IF THEN, which states "If the month is Jan AND the sales person is X" Then the returned value is Y
Thank you.
Answers
-
If you want to keep your setup the way it is I would create a hidden column called parent. Then I would create a column formula that just says =PARENT(Week@row)
Then on your other sheet you would do a sumif formula like this:
=sumif({parent column},"June",{Andrea Friske})
-
Thanks. This is coming up as unparseable. Is there another way you would setup the data to get the information I'm looking to receive?
-
Can you post a screen capture of the formula in your sheet, open in a cell?
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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!