Hello, I have been searching the community but have been unable to find what I am looking for. My organization would like to use Smartsheet to have employees submit their daily timesheet. I was able to create a form and sheet but need to create a way to separate by employee and then have a summary sheet that breaks it down…
I have come across a few instances where we have a project sheet, which includes detail items that need different columns of information than the rest of the rows in the sheet. For example, there might be a section of checklist items where we collect information. I have come up with a couple options, and am wondering if…
Hello! I know you can export to excel on a recurring basis an entire SMSH but is it possible to only select a few columns to send?
I want to create a reminder to be sent automatically 5 days after the system-generated create (date), if another column is blank. The system-generated column with the create(date) does not show in the dropdown of options for the date field. Has anyone else run into this, and if so, any suggestions on how to get the…
I'm working with Datamesh for some automations across some sheets for portfolio management. I've got an Intake form as my source sheet and then another as my target for more detailed info. I'm getting the Error! PARTIAL_SUCCESS each time it tries to run. I cannot seem to find any documentation on this error message and how…
I want a count of each time an answer is selected from a multi-select question. The countif is only counting 1 if an answer shows up once, but not counting when an answer appears more than once. Formula I'm using is: =COUNTIF({Student Satisfaction Survey Range 5}, "More live lessons") to find all the instances of "More…
My sheet is opening in grid view. I can change it to Gantt once I am in the sheet but how do I change the settings so that it just automatically opens in Gantt view?
I'm trying to include a header image for each of my client's dashboards. I had my content person create an image that spanned across my browser, that was saved as a png file. However, when I add it to the dashboard through the Image widget, it barely spans half the page, and I can't make it bigger. I want to be able to…
Hi Team, Please confirm, smartsheet providing separate server for organization or only one smartsheet server for all... Information & files stored in local smartsheet sever or any other master server...
I have a daily statistic grid set up where staff are entering new records on a daily basis. I have alert notifications set up based on when the stats are entered. The expectation is that the staff will enter their numbers via a form by 10:00 AM every day. The first automation to go out is therefore at 10:00 AM, and is…
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
Hi there, I am hoping to find a way for our staff who submit information through form to receive an email confirmation without having to get a copy of the information they fill in the form. At the moment the only email option is to have them get a copy of their response to the form, but I don't want them to have a copy of…
Hi, I am going through the "Progressive Form Save" feature of Smartsheet, and just wandering if there is a specific time period for which the draft will be saved, after which it will be discarded by itself? And also, until the form was submitted, the information will not be fed into the sheet, correct? And this feature is…
Help shape the future of Smartsheet. Share your ideas and feature requests.