-
Comparing Actual Duration to a Projected Duration with a +/- days
Three columns used are Duration(dependent), Projected Duration(I initially copy all of the durations over when setting the project) and +/- days(calculates the difference between Duration and Projected Duration) The trick here is you need to strip the "d" from the value to allow computations. =(VALUE(LEFT([Projected…
-
Hide or reveal a web form question based on answer from previous field
Is there a way to hide or reveal a question/text input field in a web form based on the answer from the previous question? For example, I am creating daily truck check forms for our paramedics and one question is "how many back rafts are there?". The dropdown list choices for them are "3", "Restocked", "Ordered" and…
-
Workflow Automation
I am sure this scenario has been discussed elsewhere. However, I was not able to find it. I am trying to create a workflow using Web Forms. When an employee fills out a request in a Web Form I would like to automatically send that Web Form (with an additional dropdown field 'Yes'/'No') to the employee's supervisor for…
-
Advanced Notifications options - add scheduled notifications.
I like the improved Notifications functionality and would like to add one more suggestion. Can you add a "Delivery" capability so that the frequency/Date/Time for the notification can be customized? This is similar to the existing functionality in SmartSheet Update Requests.
-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
Scheduled updates
Is there a plan to allow you to delete transferred owner ship tasks under the edit function? Scenario - I create 10 tasks to "owner 1" - Owner 1 requests for 2 tasks to be transferred to an new owner - I have to delete all scheduled updates for owner 1 - re-schedule, then build a new schedule for "owner 2" Under the edit…
-
Send Update Request
Hello All I want to share an exciting SS discovery! I am currently doing the Smartsheet Project Management course. The send Update Request function will truly transform my work life. This option does not require the person being requested information to log into smartsheet to answer the specific questions I require…
-
RYG Formula...
Looking for assistance. I am looking for a formula that adds the total number of individually RYG in a column that automatically populates a separate cell in a separate column. Any guidance would be appreciated. Thanks. - Erik
-
Smartsheet for Work Order System
Hi everyone, New to Smartsheet - very excited about the capabilities. Wondering if anyone out there is utilizing the system as a Work Order System? We get batch work orders from our hardware's proprietary dashboard system via email (excel). I would like to drop these into Smartsheet - using perhaps the help desk ticket…
-
Filtering Alerts
We use a sheet to keep track of documents in the review process. Is there a way to set a filtered alert so someone identified as a document reviewer gets notified when they have been added as a reviewer? Would also like to know ifthere is a way to filter an alert so that a user who uploaded a document for review only gets…
