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

TullyONeill

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

TullyONeill

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

Jason Albrecht

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?

TullyONeill

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

Jason Albrecht

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?

TullyONeill

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

Jason Albrecht

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?

TullyONeill

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

Jason Albrecht

Great news!

Glad it worked and thank you for the feedback.

Have a great day.