Help with formula (word count and hours)

I am working with sub items, and I’m trying to work out this (hopefully simple) formula:

If a column details how many words a piece of copywriting is, then the formula column says how many hours it will take. For example, if ‘words’ column is 1000, then the formula column says ‘3’.

I know I’ll have to put into the formula how many hours each quantity of words will take, but I can’t figure out what it looks like. Thank you in advance!

NVM - I solved it with: IF({Quantity}=500,2,IF({Quantity}=1000,3,IF({Quantity}=1500,4,0)))

Hi @MattRWA :wave:

So glad you were able to solve this!
Thanks for posting your formula in the Community thread.
This is hugely helpful for other users who may be looking to create a similar workflow.

As this request has now been resolved, I’m going to go ahead and close this thread.
Please do let us know if there’s anything else we can assist with!



This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.