-
Error when a customer updates a file
I have been working on a proofing system which automatically sends an update request if a customer declines their proof. Prompting them to upload new artwork. I include the attachments column on the form when asking for a new file, however when I am testing the update request I receive the following message when trying to…
-
Smartsheet Chrome app refresh
I'm using chrome app for smartsheet, and I load a report, but the report is auto updating, if the sheet is updated via VLOOKUP the report won't update till i click refresh, is there a way to auto refresh the app? thanks.
-
Data -> Exported Form
Hello, I am relatively new to SmartSheets but I am looking to place a form we have now into smartsheets to collect the data there. However our Executive Team likes the look of the original form... Is there a way to export data in a way other then in a grid/ excel looking chart? Id like to customize it and have it run only…
-
Update Requests, reminders, notifications
I'm wondering if there is a way to set up automatic update requests, reminders, and notifications to be sent on a reoccurring basis until a task has been marked as complete? I see where I can choose to have these emails sent daily, weekly, and so forth. But I don't see where I can tell Smartsheet to stop sending these if…
-
Manually Adding to Reports
I'm looking for a way to pull information from other sheets, while also being allowed to manually add data. The reason I'm doing this is to allow for staff to go to one place where we can share individuals goals, tasks and progress. Is there a way to do this? I have tried formulas, but I do not believe it updates when that…
-
Automatically marking something as complete when requirements are filled
Hello, I was wondering if someone would be able to help me with a problem that I have been struggling with. I would like to make it so that when a checkbox is checked, in another column, called status, that it would switch and say complete. The status column is a Dropbox, containing Completed, In-progress and Not started.…
-
Editing an email sent from a row
I was wondering if there is a way to have someone edit a field when you just send a row to someone. What I mean by this is would be the person receiving the email able to check completed or update a date from just the email rather than sending someone an update request?
-
Spreadsheet Filters vs Report Filters
I have a text column that has formulas and conditional formatting already added to it preventing me from changing the column type to a dropdown list. It is spread across several years of spreadsheets making a larger conversion to a list time consuming. I have a request for Report Filters to have the drop down list similar…
-
In excel you can have multiple worksheets in one document. How does this work in smartsheet?
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…
-
produce a report.
Hello, ive been asked if we can produce a report with the percentage done column like the illustration shown below?