View Single Post
Hello,

I would love for someone to write an AppleScript which creates a formula in my OmniPlan document. (Screenshot attached for reference...)

The formula I require is to work out the "Duration" of a task ie. how long it will take, based on dividing two Custom Fields/Columns I have created - the "Deliverable Count" (ie. number of web pages needing to be produced) by the "Parameter" (eg. number of web pages a developer can produce per day).

Eg. If "Deliverable Count" field is 11, divided by "Parameter" field being 10 (pages per day), the Duration field would be 1d 1h.

Please let me know if you can help!

Thanks,