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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!