Is there a better way to write this formula?
=indexrow(filter(M_Approvers,"M_Approvers[Project]=%","CFO"),1)[Approver]
Background:
I'm trying to write this cell contact with the project name of "CFO"
And write it to POs[Approver]
It works, but I don't like it.
Isaiah
2
How about this:
=FINDROW(M_Approvers, "M_Approvers[Project]=%", "CFO")[Approver]
1 Like
That did it! Thanks Isaiah!
2 Likes
system
Closed
5
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.