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

Hello Jason! That worked!!! Thank you so much!!
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

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
Help Article Resources
Categories
Check out the Formula Handbook template!