Is there a way to make links from Smartsheet to and Excel file? If so what is the best way to do this?
At first glance, I'm not quite entirely sure that's possible. If you had your "excel file" data in a separate smartsheet, you could easily link them.
Which direction are you wanting to link? Smartsheet cell update the corresponding excel file cell? Or have your smartsheet updated when the excel file is updated?
If it's helpful any, I have a current solution where we utilize Data Shuttle that will take the excel file and once attached to the Smartsheet, will update how I have mapped. Perhaps DataShuttle could be of use for you? Note - it is a premium application so if your organization does not have it, I would suggest looking into it. There is a good bit of training available on it as well.
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello. Trying to make a quick attendance tracker for a meeting. I got conditional formatting to change the cell color when its checked vs unchecked. However I cannot seem to find a way to get the rule to apply to multiple columns on a per column basis. I need a way to copy what I have for column 3 and apply it to all…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.