-
Revision Control - Best Practice
With an AS9100 Audit coming up for us, many have asked if our Smartsheet templates need to be revision controlled. Does anyone have any insight on this they could share?
-
Timecard Approval by WEEK, not by line.
Hi Community! Relatively new to SS, so I am thinking this has a simple solution. We are utilizing the timecard template but need a weekly approval from management. As of now, I can only get approval request to work by row. I do not want the managers to have to approve each row of the timecard... rather, just one approval…
-
Adjusted Dates Based on the Time a Form is Completed
I am looking to have my automatically set due dates for projects adjust if a request is put in after a certain time of day via the Smartsheet web form. Currently I have a date column where I add a certain number of work days to the timestamp depending on the department that submitted the request that acts as a due date for…
-
Sharing a report but not the source spreadsheet
I want to share part of a spreadsheet with a subcontractor. However, I do not want them to have access to the full sheet. For instance, source data: A B C D E F G H Data to share with subcontractor. They also need to be able to edit/update columns A, B, C. A B C According to the help page, this is not possible, but maybe…
-
Links in templates that can create a link on creation to a set sheet
I have a request that may already be possible so if someone can assist would be great. If not possible I believe it would be a great new feature.! We create a new sheet for each of our manufacturing jobs from a template. When this new sheet is created we then have to copy link the first row of the job sheet into a WIP…
-
Sheet ownership in the workplace
Summary : 2 questions. 1. Moving sheets in a workspace changes ownership - Why - can I stop this happening 2. Reporting in workspace does not appear to allow for additional sheets in a workspace folder to be updated to the report.?? When creating the report and the folder inside the workspace is selected it shows only the…
-
Appsheet timestamp date format
What is the trick to converting the app sheet timestamp date format to be recognised by smart sheet? On the face of it both look to be the same. timestamp format from within smartsheet is = 3/3/2018 11:48:41 timestamp format inputted from appsheet = 3/3/2018 11:48:41 I tried the DATEONLY() function on the app sheet date…
-
How do I change a user's login name
What is the correct process for changing a user's login name after they have a name change (marriage, incorrect spelling when created, etc) I see I can change the first name / last name, but I'm not able to find out how to change the login / email address.
-
IF formula to combine rows if checkbox checked
Is there a way to do this? I would like my Primary Column (Task Name) to combine it's text with my 'assigned to' column if the condition of the checkbox in column 'Show' is checked. thanks Mike
-
Formula Date Remaining Static
I have aprroximately 30 sheets related to a corporate merger. In every sheet I have a formula that populates today's date +1 whenever a status column value = Complete. The formula is: =IF(Status2 = "Complete", TODAY(1)) This then triggers a reminder to a supervisor to review the task and approve its completion. So, the…