Multiply
Is there any function similar to "Multiply" of excel?
Answers
-
Do you mean multiplying one column by another column?
=[Column A]@row * [Column B]@row
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I'm not sure this is a joke Paul, but I'm going to pretend it is hahahaha...I wanted to say if there was a formula to automatically multiply ranges, like the "Multiply" function in Excel, so I could use it within a function of "SUM". Thanks for the help too!
-
Hey @Gabo Flocco
Can you post a screen capture with example/test data to show what you mean? How are you looking to multiply values?
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Gabo Flocco There is no MULTIPLY function in Excel other than using the asterisk. Your most recent comment mentioning ranges though leads me to believe maybe you are talking abut the PRODUCT function?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Good morning Paul. Yes, I'm talking about the PRODUCT function, exactly. There's something similar en Smartsheet?
Thanks!
-
Unfortunately not, but there may be other options to work around it depending on your exact needs.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Ok, I already have a work around, but I still would like to know about when this function appears .
Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!