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

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?

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.

Ok, I already have a work around, but I still would like to know about when this function appears .
Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!