Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I have an Excel sheet that I pull data into from another system and then run a macro to organize it the same everytime. Is there a way to simply upload that new data over an existing sheet so I can use the new data to refresh/update a dashboard connected to that existing sheet?
Not directly, no. Import to Smartsheet is to a new sheet.
Options include:
1. AppSheet
2. X-Sheet References.
3. API
and likely others I have not explored or have neglected to mention.
Craig
I have created an educational tool for our study teams to guide them in meeting Clinical Trial Transparency Best Practices. I've confirmed that I can publish a sheet with all columns and rows locked except for one cell. This cell has a dropdown column that is updated nightly via a data shuttle. People with access to this…
I am using Smartsheet on an Individual (Pro) plan. The red unread conversation indicators on rows no longer clear after I open and read the row conversations. I have already tried: Opening every conversation and scrolling through all comments. Using Mark all as read. Refreshing the sheet. Hard refresh (Ctrl + F5). Testing…
I have two sheets that use the exact same workflow: Trigger: When rows added/changed When checkbox - checked Send to contact in a cell Then record date In one sheet the workflow works as intended. In the other, the workflow appears to work (date is recorded) but no notification is received. I have already confirmed that…
