-
Report on Resource Utilization on a Single Day
I have a project plan that was created by importing a plan from Project. I would like to create a report that shows the resources and their utilization on a single day. The only filter I see in the Report Builder is to filter on the Start Date or the End Date of a task. I want to see anyone who has tasks that occur on a…
-
Printing and including Workspace on PDF
Our company rolls out many Workspaces which reflect individual projects. We provide copies of project Sheets in a printed PDF format for our clients - the Sheets reside in each project Workspace. When printing, the Sheet name is included - via the checkbox (per attached). It's quite oversized. (I've attached an example…
-
RGY Balls and Days remaining
Currently, I am using this formula =IF([End Date]396 < TODAY(), "Red", IF([End Date]396 = TODAY(), "Yellow", IF([End Date]396 > TODAY(), "Green"))) for health status. What I would like to do is tweak this, so that if a task is less than 75%, and due in 3 days, the ball is YELLOW. Everything else remains the same
-
Automate Notification
I am trying to find a way to use the DONE checkbox to then notify the dependent task assignment that it is ready to launch. I have looked for solutions and come up with the idea of having a handoff column, but then that is just putting the same information twice in the sheet. What I am wondering is if there is a way to…
-
VLOOKUP to another SmartSheet
When will we have the ability to VLOOKUP a value on another sheet? I link to a cell in another sheet now when the location is static....but in this situation the value is not in a certain cell.
-
Automatic Convert Email Address to Hyperlink
Anyway Smartsheet can recognize the value in a cell as an email adreas and convert it to a hyperlink? Based on value in a cell in Sheet 2, an email address is "pulled" from a cell in Sheet 1. However, its text, not an email address contact/hyperlink. Ultimately, I need to have a way Smartsheet can use the email address to…
-
Multi-level approval notification challenge
Hi There, I am try to create a multi-level approval form, where I have created several columns to hold dynamic approver names (based on the submitter), based on a specific set of criteria. I then use a VLOOKUP formula to populate the text field from a contact field in a 'reference' SS containing the relationships of…
-
Contact Column Enhancement Request
1. Please allow me to at least use an if statement for contact columns. 2. It would be nice to be able to reference 2 emails, either / person or even /cell. 3. Please allow for a phone number to be associated to a person in the cell. I want to send texts, and I know I can send a text via email, but if their email is…
-
Referencing a Contact with VLOOKUP
I have an employee list that has a column for "supervisor", which is a "Contact" type column, allowing the selection of a supervisor from a pre-defined list. I have another sheet, a time sheet, which needs to reference that supervisor column with vlookup so that approvals can be sent to that person for hours logged. It…
-
Multiple contact list in a column
Hello, Is there a way to create multiple sets of group contacts or drop down lists in a single column so that only a specified set of contacts or individuals can be selected based on what information is selected in a drop down list from an adjacent column? For example, if I have 100 people in a contact list but, they are…