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
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!