Using Formula answer in another Formula

Hi Chris,

if your not able to refer to other formulas, you will need to add the existing formula into the new formula e.g

formula 1 - display long for all task over 10 days and short for less than 10 days

if(duration > '10d', "Long","Short")

formula 2 - depending on the result of Long or Short display different messages

if(if(duration > '10d', "Long","Short")="Long","Task over 10 days","Task less than 10 days")

I would always recommend that when building a new formula, build it in small sections so you know that each part works.

Thanks Chris.

Keeping them simple, and a lot of trial and error is the only way i can get a formula to work, so was hoping to avoid creating complex Formulae. If you're able to help, i've posted again with the details of the specific formula:

http://www.planningplanet.com/forums/asta-powerproject/537833/formula-duration-between-tasks-based-code-library-allocation

Thanks,

Chris