Multiply

Gabo Flocco

Is there any function similar to "Multiply" of excel? 

Paul Newcome

Do you mean multiplying one column by another column?

=[Column A]@row * [Column B]@row

Gabo Flocco

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!

Genevieve P.

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?

Paul Newcome

@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?

Gabo Flocco

Good morning Paul. Yes, I'm talking about the PRODUCT function, exactly. There's something similar en Smartsheet?

Thanks!

Paul Newcome

Unfortunately not, but there may be other options to work around it depending on your exact needs.

Gabo Flocco

Ok, I already have a work around, but I still would like to know about when this function appears .

Thanks!

wtang82236

Paul, yes, what are the work arounds you are thinking of for this? I have a similar need.

Ex: =product(A1:Z1)