How to calculate values in a row?
Hi,
I am just new in smartsheet, how can I calculate values in a row ?
Please help.
Thank You!
Answers
-
To reference a range in a function, you want to list the first column name and row number (ex- [Column One]1)
Then, put a colon and reference the last column and row number (ex - [Column One]1:[Column Three]1)
Now, if your calculations will always be in the same row as the range, instead of saying 1 or 2 for the row reference, you can use something called @row to tell the formula just to look within its own row (ex - [Column One]@row:[Column Three]@row)
It looks like you want to have an Average... try this:
=AVG([Column One]@row:[Column Three]@row)
I'm not sure what you want to do for the "count", does this indicate a SUM of the values? If so, try this:
=AVG([Column One]@row:[Column Three]@row)
Once you have these formulas in one cell, you can use drag-fill to bring that same formula down through the whole column and it will create these calculations per row. Keep in mind that you'll need to replace your column names with the ones in your sheet.
Let me know if this has answered your question! If not, it would be helpful to see a full screen capture of your sheet with the column names/types, but please block out any sensitive data.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!