Explore Charting Possibilities

Follow New post
0

Formula referencing another formula.

I am using {{=UPSTREAM."Department"}} in an org chart to populate an employee attribute based on their manager.

In the example below the top level employees Department is a set value, the two employees below pull the department value using the formula, however the third level employee just pulls the text of the formula rather than the result. Is this expected behaviour, or am I doing something wrong?

 

Thanks

Jonny

1 comment

0
Avatar

Hi Jonny,

Thanks for reaching out, and sorry for the trouble. In order to use formulas, I would recommend adding "Department" as custom data fields on the shapes themselves, as opposed to an org chart data field. For example, in the screenshot below, I have added "Department" as a custom data field with the value "Sales" to our example CEO, and then am able to reference it using formulas when adding custom data to the VP. Hope this helps! 

Tate S 0 votes
Comment actions Permalink
Please sign in to leave a comment.