Explore Charting Possibilities

Follow New post
0

SUMIF Equivalent

Hey folks, looking for a solution to another seemingly simple situation. I have three connected shapes. In two I have a single line of imported data from an external source. The fields are (example): "project_name", "manager", "value".

In the third shape I would like to sum the "value" fields only when the "manager" field is equal to a certain value (e.g. "Bob"). Generally this would be as simple as =SUMIF(manager,"Bob",value). But I can't find a combination of Lucidchart formulas to accomplish the same.

Is there a way to do this without smart containers?

Thanks!

1 comment

0
Avatar

Hi Bojan, 

Thanks for reaching out in the community! Unfortunately, Lucidchart does not currently support that formula. However, we are always looking for ways to improve our product. If you'd like to see this functionality added to Lucidchart in the future, please add your idea to our Feature Request Form. 

You can find more information on how to use the formulas currently available in Lucidchart in this Help Center article

Thanks and please let me know if you have additional questions!

Flavia D 0 votes
Comment actions Permalink
Please sign in to leave a comment.