Create an automatic calculation - Excel alike

Davide Tagliapietra

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.

Bassam Khalil

Hi @Davide Tagliapietra

Hope you are fine, when you select a group of cells in smartsheet you will have the same check the following screenshot.

Davide Tagliapietra

Hi @Bassam.M Khalil and thank you! How can I do if they're not numbers as in your example but names?

Sandra Guzman

Hi @Davide Tagliapietra

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

Bassam Khalil

 @Davide Tagliapietra

you can use Also the great idea from @Sandra Guzman  you can use Also