Using Formula answer in another Formula

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

C
Chris Ray 👤 Member for 13 years 2 months

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.

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts