formula
HI all
I am trying to create a formula and not having much luck,
I am trying to work out a weighted total using a weighted figure which multiplies by a number in another cell but there are 14 other columns that need to do the same and add into the total
so = row1 cell "data incorrect" * Row 9 + same formula for all the others  totaled into the total cell at the bottom left ( hope this makes sense)
Answers

If I'm understanding you correctly, you need the cell in the "Weight" column to be multiplied by the cell in the top row of whatever column the formula is in.
In this case, I would use the @row feature to first reference the Weight in this current row:
=Weight@row
Then you can * or multiply this by the cell in row number 1. We can use an Absolute Reference ($) to keep the formula always looking at row number one: $1
=Weight@row * [DATA INCORRECT MAJOR Non Compliance]$1
We'll also want to add an Absolute Reference to the "Weight" reference, so our formula always looks at that first column:
=$Weight@row * [DATA INCORRECT MAJOR Non Compliance]$1
Then you can drag this formula over to the right, across all rows. This will update the cell reference in the top row to look in the current column while keeping the first reference always looking at the Weight column. See: Create a Cell or Column Reference in a Formula
If I misunderstood and you're also looking to multiply the values in row 4 (your totals) along with this calculation, you can include that as well:
=$Weight@row * [DATA INCORRECT MAJOR Non Compliance]$1 *[DATA INCORRECT MAJOR Non Compliance]$4
Let me know if this has helped!
Cheers,
Genevieve
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.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!