-
Filter on columns with values populated by a formula
Hello. After searching and coming up empty handed, I decided to post for help. I have columns in a sheet that are populated by VLOOKUP functions. Whenever I run a filter on one of those columns, all 1703 rows of my sheet are in included or excluded. As an example, if I set a filter on the "Effective Price To" = "is not in…
-
Print a form
We use a form for our recruiters to enter candidate information into Smartsheet. After they complete the form, they need to print it for the employee record. how can we do this?
-
Enhancement Request: Auto-Refresh Functionality
I would like to request the addition of an auto-refresh feature within Smartsheet. I use one worksheet most of the day and I have to manually refresh the worklist several times each hour. It would be great if the auto-refresh feature could trigger anytime someone performed a change but I would settle for an auto-refresh…
-
Credentialing Tracking Template
Hello, I am looking to set up a credentialing tracking template. I would like to track the credentialing process including but not limited to documents submitted/pending, approvals, etc. I'm curious, does anyone out there have any examples of such templates? Any ideas are much appreciated. Thank you!
-
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.