Formula for division (mix of information in a row and dividing by a number)
hi!
In my Smartsheet tracker, I have a row titled "word count" and another titled "SLA forecasted time".
In row "SLA Forecasted time", I need a formula which will be the number in the "word count" column divided by 2,000. EX: 6,000/2,000=3 .
I have tried so many ways to get this thing done and it's not happening. Can someone please help??
Best Answers

Hi Jason!!
Thank you so much for the help! Thankfully, my question is even more simple.... I don't need to count up the words because it's a data point that is manually entered.
I need the number that's in the "word count" row to be divided by 2,000 and populated into a row on my sheet. I'm having a very hard time with selecting the row or cell in question. I've tried formulas with ( [ and more but, I keep getting an error message. In Excel, my formula looks like =(D30/2000) .

Hi @TullyONeill
Thanks for the clarification and my apologies in not reading your question carefully.
Am I right in understanding that you've already tried the example in the picture?
=[word count]@row/2000
Am I right in also understanding that the number in the "word count" column is indeed a number and seen as text (either from formatting or with any space or apostrophe in front of the number)?
Perhaps using the VALUE Function wrapped around the "word count" number might help? e.g.:
=VALUE([Word Count]@row) / 2000
Hope this helps?
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile  Open to work

Hello Jason! That worked!!! Thank you so much!!
Answers

Salutations,
Do the answers from this post and this post help at all?
I imagine the formula divided by 2000 should provide the answer?
Does this help?
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile  Open to work

Hi Jason!!
Thank you so much for the help! Thankfully, my question is even more simple.... I don't need to count up the words because it's a data point that is manually entered.
I need the number that's in the "word count" row to be divided by 2,000 and populated into a row on my sheet. I'm having a very hard time with selecting the row or cell in question. I've tried formulas with ( [ and more but, I keep getting an error message. In Excel, my formula looks like =(D30/2000) .

Hi @TullyONeill
Thanks for the clarification and my apologies in not reading your question carefully.
Am I right in understanding that you've already tried the example in the picture?
=[word count]@row/2000
Am I right in also understanding that the number in the "word count" column is indeed a number and seen as text (either from formatting or with any space or apostrophe in front of the number)?
Perhaps using the VALUE Function wrapped around the "word count" number might help? e.g.:
=VALUE([Word Count]@row) / 2000
Hope this helps?
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile  Open to work

Hello Jason! That worked!!! Thank you so much!!

Great news!
Glad it worked and thank you for the feedback.
Have a great day.
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile  Open to work
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!