sum a multi-line text and numbers cell
Ahmad
✭✭
Hello all,
I have a sheet need sum number in multiline cell like:
A1 = 80 GB
A2 = 100 GB and 1 TB
A3 (Total) = 1180 GB or 1.18 TB
Answers
-
Is there any way to clean up the input coming into this sheet? If you just standardized the input in GB then you could just do a simple sum and then a division that would show your TB at the end.
-
I knot that bro, but this simple of file I have
and also I can use =SUMPRODUCT(--SUBSTITUTE(I4,"GB","")) and the same with change GB to TB
But also need sprite GB and TB to 2 Colum
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!