How can I save time ?

mBekri

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.

Paul Newcome

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?

mBekri

https://community.smartsheet.com/discussion/comment/301235#Comment_301235

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.

Paul Newcome

Are you bale to provide some screenshots for reference?