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!