Excel to Smartsheets Formula
Hello!
I am working on transforming an Excel i previously used to Smartsheets and need some help with the formulas. I was able to import and it worked.. however i am creating a whole new template in Smartsheets and though i can get the formula to work when i try to convert to column formula it tells me the formula syntax isnt quite right. What i have right now is
=[Hours Worked]16 / 8
So equal to the hours worked in row 16 divided by 8
Best Answer

Hey!
Should be a simple fix on this  anytime you're doing a column formula in Smartsheet it must reference "@row"
So your formula would be:
= [Hours Worked]@row/8
Then you can convert it to a column formula which will run on every row.
Let me know if that fixes the problem or if you have any other questions!
Jon Mark
Answers

Hey!
Should be a simple fix on this  anytime you're doing a column formula in Smartsheet it must reference "@row"
So your formula would be:
= [Hours Worked]@row/8
Then you can convert it to a column formula which will run on every row.
Let me know if that fixes the problem or if you have any other questions!
Jon Mark

Yes! That worked Thank you so much @Jon Mark H
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 380 Global Discussions
 212 Industry Talk
 444 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 290 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!