# Formula for division (mix of information in a row and dividing by a number)

Options
✭✭✭

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??

• ✭✭✭
Options

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) .

• ✭✭✭✭✭✭
Options

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

• ✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭
Options

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) .

• ✭✭✭✭✭✭
Options

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

• ✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!