Formula is changing after a date sort

Once my data is in the appropriate cells I want to perform a sort by Due Date. When I do this

the formula

=SUMIF($Equipment5:$Equipment171, "VUTEK", $Tue5:$Tue171)

Changes to

=SUMIF($Equipment16:$Equipment171, "VUTEK", $Tue16:$Tue171)

Thus not including any data from rows 4 thru 15.

I have locked the row with the formulas but does not work.

Find more posts tagged with

Manufacturing

Without seeing the organization of your data, here's some tips:

Sorting will mess up references.

If you have Absolute References ($Column$Row) then if the row is not first or last, the range will shrink.

Try either:

1. Using the whole column

=SUMIF(Equipment:Equipment, "VUTEK", Tue:Tue)

2. Using hierarchy and summing the children

=SUMIF(CHILDREN(Equipment4), "VUTEK", CHILDREN(Tue4)

(assuming row 4 is the parent)

I hope this helps.

Craig

Check out the @row feature.

Craig

Forms
On the App - "In Smartsheet forms, is there a way to capture or upload an image directly into a specific column cell (per row) without using the Attachments field? I need each section of the form to have its own dedicated image, not just general attachments for the row."
Smartsheet Mobilizer Kit2/Best Practices
Hi - I am launching Smartsheet sessions at my organization for the next 3 months. The SS Mobilizer Kit2 Workspace I saved a few years back, the files are not loading. Is there a new resource kit? Also, I am writing up some best practices for our users: Examples: Names, separate first and last name into two columns. Email…
Workspace is still there but all folders are empty
Hey, I had a Project in January where I created multiple sheets, dashboards etc. Now I want to prepare the same project again but all folders are empty. Not a single sheet is left. How is that possible ? I upgraded to a paid account during that time and Iwanted to do that again but smartsheet do not delete everything if…