How can I save time ?
Hello,
I have been working on a project recently and need some advice about the cells and the references.
I am looking for a way to apply a function to every cell in a column by calling another sheets columns.
The only problem is that I have to do that one by one.
That's why I am asking if there is a way to automatically fill the cells with the functions while using different references from another sheet.
Answers
-
So each row has a different reference? What is the formula you are wanting to use? Can you describe you process and possibly provide some screenshots?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
The formulas I am using are SUMIF and AVERAGEIF and I am trying to put the sum of each column in a different cell depending on the name of the field. For example,
"=SUMIF({Sheet Range 1}, "Management", {Sheet Range 2})."
"=AVERAGEIF({Sheet Range 1}, "Management", {Sheet Range 2})."
The first reference (Sheet range 1) would be the field and should always be the same as its where the field is entered, while the other one (Sheet Range 2) would be different depending on what column I am referring to.
-
Are you bale to provide some screenshots for reference?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.6K Get Help
- 370 Global Discussions
- 202 Industry Talk
- 433 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 281 Events
- 31 Webinars
- 7.3K Forum Archives