Sign in to join the conversation:
Unable to lock smart sheet data in the excel once I export to Excel - I am loosing all the filters which I applied in the smart sheet. Need some help/advise.
Make a report. Use the report builder to populate your report with the records that you would see in the filtered sheet. Export the report records to excel.
I don't understand the issue with locking … can you explain further?
I'm on an enterprise license. I use the live data connector to link excel with smartsheet sheet(s) and report(s). It's has limitations (sharing/security) but it eliminates the need to constantly export data. A plus is that the excel sheet can be refreshed to reflect changes in smartsheet data.
Is there an easy way to quickly drag down the same cell values to 1,000+ cells? Important: I have the sheet filtered, as I only want this to be copied to specific rows. I have over 1,300 rows on the sheet, so I can't just use the column formula functionality. I was hoping I could just double click the bottom right corner…
Hi everyone, hoping for a little help here, I recently did a survey of 240 employees with 9 yes or no questions. I am hoping to create either a linebar or stacked linebar graph showing the 9 questions in a single chart with the question being on the left axis. When I try to do a report to create this graph, Im unable to…
I have given someone access as an Admin to allow them to create new sheets and edit existing and they keep being told they do not have access to edit. What could be causing this?
