Using Formula to link cells
Hi I am hoping someone can help me with an answer to this.
I have for some time now been using a formula in various project management logs, to link to a contact cell in a Calculation sheet where the name of the Project Manager resides, pulled from our Metadata sheet on project roll up via Control Centre.
Then I use that referenced column in the log to run an automation to notify the Project Manager of certain changes to the sheet. This has always worked successfully until fairly recently. When I link the cell using the formula it will always pull through the Contact correctly, but for any new project sheets the automation will no longer work. I believe that there is a note somewhere that automation's will not run with linked cells, but this is not using the 'Link cell from other sheet' function, it is referencing off a formula and does still work for old logs. All I can think is that there has been a change to the functionality of automation's hence it wont work for newly created sheets. Long shot but hoping someone can advise.
Help Article Resources
Check out the Formula Handbook template!