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.
Hello, I have a metrics reporting sheet that relies on cross sheet reference formula to count rows from a formula column in a source sheet (let's call it Sheet A) that refreshes with data via data shuttle (set to 'Replace all target sheet rows with the data from the input file') once per day at 8 AM UTC (I am in PST). One…
Dear Community, I have created a form where the contact field is mandatory. If no value is selected in this field, the form correctly shows the error message: “This response is required.” However, if I select a name and then remove it, the field shows a remaining circular icon, and the form gets submitted without any…
I have no idea how to start the program. I need the basics on how to build charts and graphs.
