Simplifying a Formula

1

Hi folks! I’m trying to improve my efficiency with formulas, and I wanted to get your thoughts on how I could simplify the formula below (also attached a picture). I’m populating the corresponding “Role Notes” on our Hub for the user’s position. I was able to do it using Switch and Filters.

Switch([Position Name],‘Production Manager’, [Company Roles].Filter(Role=“Production Manager”).[Role Notes],‘Sr. Editor’, [Company Roles].Filter(Role=“Sr. Editor”).[Role Notes],“Managing Partner”,[Company Roles].Filter(Role=“Managing Partner”).[Role Notes],‘Sr. Designer’,[Company Roles].Filter(Role=‘Sr. Designer’).[Role Notes],“Designer”,[Company Roles].Filter(Role=“Designer”).[Role Notes])

image
image924×562 85.5 KB

Many thanks!

2

And right after I posted this, I was able to get the same results using this! Definitely a lot shorter

Switch([Position Name],[Position Name], [Company Roles].Filter(Role=[Position Name]).[Role Notes])

image
image876×166 30.4 KB

1 Like
3

I get the distinct feeling that you should consider the Compose type field. It may offer you even greater simplification to achieve these types of aggregations.

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.