Project intake from non owned non admin shared sheet
I am new to the smartsheet program, and learning quickly, but I have a new problem I am trying to work through.
I have shared access to a vendor smartsheet that does one piece of my customers work. This shared is a tracker that has multiple sheets funneled into one sheet.
I am wanting to import key information from their page, have it populate as rows are added, subtracted, etc so I do not have to re create the wheel every time a new project is added, or the status of their project is changed. Then I will add my key information, such as project managers, stakeholders, etc that is relevant on my end.
Problem is, I do not have admin rights or ownership rights to their page, and cannot get it. What are my other options to be able to import that data as it happens?
I created a report and it shows the data and changes, but I cannot pull data from the report and utilize it.
thank you in advance.
Help Article Resources
Check out the Formula Handbook template!