-
Setting an alert of Green Status
Hello everyone, I am very new to SS and would like your help on the following topic: When the Status goes to Green (only on green) to send an e-mail to a specific person. All that I am getting is everytime I change status to any color will send the e-mail. Thank you
-
Filter Resource View
Resource Views are handy to work with however as I try to balance/level our resources it would be a lot easier to have a way to automatically filter a user resopurce view to only show over-allocated resources. Currently have to run for all resources then just look at ones with red heads icon in allocatrion column. While…
-
Create percentage complete based of boxes checked
Hello, I am very new to smartsheet and still quite inept. I have a smartsheet that I am using to track a student I am mentoring. There is a coumn titled 'Completed'. This allows the student to check when a specific task is complete. I want to be able to show the percentage complete based off how many boxes are checked as…
-
PLANNED VERSUS ACTUAL PROGRESS
hi, is there a way that i can see the planned versus actual progress of the project ? baseline versus actual? thanks.
-
Webforms - The same required fields for multiple items
Hi, Is there a quick way in a webform to create the same required fields for a specific item selected from a drop down list? For example - You select a item from the drop down list and then the required fields appear underneath it:- Dropdown list (Item description): Curtains Walls Kitchen tiles The following then appears…
-
Date Format - Add the time eg 14/01@0930
Is there a formula available so I can create a date like the following? 14/01@0930 or is there any plans to have more date format options? Such as DD/MM @ HHMM
-
Editing a submitted webform
HI, Is there a way that a person filling out a webform can "call up" the submitted form and make changes and resubmit?
-
Predecessors "tolerant" to deletion
I'm trying to figure out if there's a way to set up our projects so that some very specific tasks, which may normally be predecessors to other tasks, can be DELETED without resulting in an ugly "#REF" error on the subsequent row. We would want this because we have several different "tiers" of projects depending on the…
-
Using a formula =CONTACT wont populate actual contact info subtasks
Help! At the top of my projects, I am including the resources involved. I'd like for subtasks to be auto-populated when I fill in a resource. Example: in my resources section, I set the HL7 Engineer to Joe Downing. I have it set so all HL7 tasks then populate with Joe Downing. PROBLEM: Joe Downing's contact info doesn't…
-
Setting Alerts for new Webform submissions
We are using webforms to gather feedback after a system upgrade. Is there a way to set an alert to send an email when a new item is added through a webform?