Help

Re: Formula for Daily Minimum

Solved
Jump to Solution
855 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Heather_Slade
5 - Automation Enthusiast
5 - Automation Enthusiast

Can anyone help me with a formula? Here’s what I want to do:
Take a total number of words: for example, 60,000
Subtract my current number of words: for example, 20,000
And then take that number (40,000) and divide it among the number of days left before my deadline.

TIA!

Screen Shot 2021-05-30 at 1.37.38 PM

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

The number of days left before your deadline is a formula field that displays a string of text, not a number. You need a formula based on the original due date (date field) and calculate the number of days remaining as a number, not a text string.

DATETIME_DIFF({Due Date}, TODAY(), 'days')

Then subtract and divide as you described.

( {Final Word Count} - {Current Word Count} ) / {Days Remaining}

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

The number of days left before your deadline is a formula field that displays a string of text, not a number. You need a formula based on the original due date (date field) and calculate the number of days remaining as a number, not a text string.

DATETIME_DIFF({Due Date}, TODAY(), 'days')

Then subtract and divide as you described.

( {Final Word Count} - {Current Word Count} ) / {Days Remaining}
Heather_Slade
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks so much for your help!