Multiplying Number in One Column, Result in Next Column
Hello,
I am trying to create a function to take a number from one column, multiply by a set amount and to return the result in the next column, but I am not finding an easy function for this.
I am familiar with doing this in Excel, but not SmartSheet.
Thank you!
Jackie
Answers

Well, you can write something like this where it will multiple the value in Column1 of the same row by 5:
=[Column1]@row*5
Or you can write something like this to multiply Column1 by Column2:
=[Column1]@row*[Column2]@row
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 36 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!