Create an automatic calculation - Excel alike
Hi everyone,
I would like to create an automatic calculation like in the image above when selecting some row or an entire column.
How can I select such solution?
Thank you.
Answers
-
Hope you are fine, when you select a group of cells in smartsheet you will have the same check the following screenshot.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Bassam.M Khalil and thank you! How can I do if they're not numbers as in your example but names?
-
Just like @Bassam.M Khalil demonstrated above, you can also highlight text (or the names you are referring to). The document will provide you with a COUNT for the data listed. You won't get the other details (SUM or AVG) since the data you are selecting is not a number.
All the best,
Sandra
-
you can use Also the great idea from @Sandra Guzman you can use Also
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!