Hey there!
Im not sure exactly what you are trying to do, but two things come to mind:
(1) WithName()
WithName() is a wonderful formula that allows you to write a complex longer formula and then give it a short name to reference it by.
Once you create it’s short name you can reference that anywhere else within the same formula
Heres some documentation on withName(): [DOCUMENTATION]
Heres a screenshot of it working. Noticed how I named this longer filter() formula as allPeople and then was able to reference it twice later on
(2) Named Canvas Variables
You can write any formulas into the canvas and then give those a Name - that named formula can then be referenced anywhere within your docs at any time and can utilize its ouput. I normally keep a dedicated hidden page in all my docs just for this purpose.
I can explain one use case around that very thing in this video where I create a named variable titled giveAccess which then allows the doc creator to filter tables conditionally and easily based on who is logged into the doc.
Always name your canvas based variables!
