Hi all,
Does anyone know how to / if you can refer to an answer of a formula in part of another formula?
If you can, could you please explain how?
Kind Regards,
Chris
Hi all,
Does anyone know how to / if you can refer to an answer of a formula in part of another formula?
If you can, could you please explain how?
Kind Regards,
Chris
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
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.