-
Constraints in predecessors in SmartSheet ?
Hi, I want to create the gantt with schedue as below: Task A Subtask A1 Oct 15 to Oct 19 Subtask A2 Oct 15 to Oct 19 Subtask A3 Oct 22 to Oct 26 Subtask A4 Oct 29 to Nov 2 Predecessors of A3 = Subtask A1 and Subtask A2 Predecessors of A4 = Subtask A1 and Subtask A2 Subtask A3 and Subtask A4 are assigned to the same…
-
Location of Web form submissions in SmartSheet
We have generated a SmartSheet webform to link with an existing work resource tracker. We have found that the webform entries occur far below the existing list (e.g., ~ 200 rows below). Is there a way to adjust where the webform entries occur once submitted (e.g., below the last row in the sheet)?
-
Simple question, but unable to figure it out.
HI all, New user of SS and I am stuck trying to figure this out.. If I have a task that is 10 days to complete with 1 resource, but if I assign 2 resources it will be completed in 5 days.. It is still 10 days of effort however it has now reduced the project length by 5 days.. What do I need to do to effect the dates…
-
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!
-
SUMIFS with VLOOKUP
On a sheet I call "Project Group Hour Totals", I am trying to add the hours from a sheet I call "Project Time Tracker", using VLOOKUP to find both my Project Category and my Project group. My Project Time Tracker Range 1 is the hours column on the project time tracker, and Range 2 includes 6 columns. The project Number…
-
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…
-
Dashboard Widgets PDF Issue
Hi Community, Need some help with exporting Dashboards to PDF. Seem that all the widgets export extremely low resolution. The text seems to be fine, but all widgets regardless of how large or small i make them export low resolution and pixelated. I need to send some dashboards at PDFs and not live URLs so this is a must…
-
Notification of new comment - not to assigned user
Hi, I am new to SS and trying to find my way around. One question I have is how to send notifications when comments are added. I can see that I can send notification when column changes and choose comments column. I can then select to send it to a contact in column, and choose assigned user. However, if someone comments on…
-
Smarsheet data share over mobile no instead of email
Hi everyone At present I am sharing data with others over their email addresses. Is there any method of sharing data over their mobile no? Say user has a what's app installed on their mobile and status update request or report can be shared on mobile?
-
Blocking already selected dates in Smartsheet Forms
Hi All, I have a smartsheet form setup to allow users to book events. I have added a calendar option in there to allow them to choose the date. I would like to block/grey-out the dates which have already been chosen. Currently I see no option when editing the Form which would let me do that. Is there a native way to…