Sign in to submit new ideas and vote
Get Started

Generate cross sheet reference names using formulas

Instead of manually typing the reference name, it would be extremely useful if it could be allowed to generate the string into the curved brackets using a formula. In the same way it would useful also using Summary sheet fields in it.


=INDEX(COLLECT({Sheet1_Name}, {Status}, "Enrolled"), 1)

could be

=INDEX(COLLECT(("{Sheet"+[Sheet number]#+"_Name}"), {Status}, "Enrolled"), 1)


=INDEX(COLLECT((JOIN(Ref1:Ref3),""), {Status}, "Enrolled"), 1)

where Ref1 Ref2 Ref3 contain the part of the string to build.

1 votes

Idea Submitted · Last Updated