-
Feature request to optionally recieve notifications only in SmartSheet
Would it be possible to add an option for notification of change alerts to be limited to the SmartSheet notifications menu and not be sent email? I am finding that with some project teams, the email alerts for updates, that are not actually assignments being made or changed are 'noisy' to team members. Once they are aware…
-
Stacked Charts
Hello 1. I am new to the smartsheet community and would like to know if it is possible to plot dates using the charts widget in the dashboard. I intend on plotting a stacked bar chart with dates and duration. (As show in Figure 1) 2. While using the clustered bar charts option, is it possible to a merge the bars, something…
-
Find next / subsequent date in list
Hi, I am stumped. I am trying to figure out how to figure out the second (and third) date for each unique entry in the Provider/Resource column. I am using this formula to find the first date: =IF(Date@row = MIN(COLLECT(Date:Date, [Provider/Resource]:[Provider/Resource], =[Provider/Resource]@row)), Date@row, 0)
-
Updates on a ticketing system
Hello All, we are setting up a ticketing system to manage a medium (but growing number) of instruments. Unfortenately not all service requests can be handled in one visit. How can the "actions taken" column be updated lets say from zero to several times. In the best case each update corresponds to a service visit date. Any…
-
signing smartsheet input forms
Does anyone know how to sign input Smartsheet forms? I know that Smartsheet and Docusign integrates. However, I'm not sure how that would work in input forms.
-
Notification of Assignee when predecessor is 75% complete
All My project team members want to have "look ahead " insight into tasks they have upcoming. Is there a way to notify the assignee of the successor task when the predecessor is 75% complete, or x number of days from completion. Currently they receive the notification the day the task is to start. Any suggestions are…
-
Equipment Check-out...
Has anyone implemented a sheet for use as an equipment check-out form? That is a web form that is filled out by the user which allows them to select from a database of available equipment and indicate the length of use in days? I think I could do that with a column dropdown list populated with the items that are available.…
-
Summing up everyday new entry value into a different smart sheet
Hi, Can anyone give me some idea on Summing up across multiple smart sheets new entry value in separate smart sheet please. I can sum up specific cell values or range but i am looking for sum of daily entered values of same column from different sheets.
-
Access of a Report via Dashboard
Background: I have created a form to capture Company personnel’s proposed ideas to improve cost savings, quality and safety. With this I have also created a Dashboard to give a snapshot of the progress of all Idea’s submitted. On the dashboard I created a button that I had intended for a person without a Smartsheet sign on…
-
Report Publishing...
I want to be able to publish a report link for editors to update a project status the way I can publish fully editable links via the sheet itself. Why can I only publish secure links for reports that require a login? I want editors to have access to change information in a report without logging in. What am I missing?