-
Resourcing is looking at SCC template gantts
Firstly, yes - I know the Control Center sheets are not "templates" but I would want resourcing to be able to filter out the workspace or at least the folder used to spin up SCC projects. Since I pre-load "assembly time" by assigning it to the genaric "Assembly" contact in ALL of the grouped gantt schedule options (of…
-
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…
-
Moving Contact Information from SharePoint to Smartsheet
I'm trying to setup a Microsoft Flow to move data from a SharePoint list to a Smartsheet. The problem I'm running into is that the Contact column type in Smartsheet won't accept the "Person" column type data from SharePoint. I continue to get this error: Value is not supported for this column type. Use objectValue instead.…
-
Can you do if this then that for auto entry from drop down list
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the…
-
Auto-filling columns in Smartsheet
I have created a form which captures computer name, name, and email address of the person on the smarsheet in addition to the other data they are submitting. Is there a way I could use the formula to auto-fill name and email address for repeat users referencing the machine name either on the form or on smartsheet?
-
Automation: Request an update but my contacts are not in a contact column
I'm working on a sheet that has a formula that is running an INDEX/MATCH to populate the Carrier Contacts based of the trucking company's Unique SCAC code. The fomula is working great now and I have the cells populated with the email contacts for the carriers. I am now trying to write an automation "Request an Update" but…
-
Automation: Request an update but my contacts are not in a contact column
How can I work around this issue. My sheet is populating the "Contacts" via formula. I want to trigger automated update requests but am running into issues since I'm unable to convert the column type to "contact" since it appears that Smartsheet doesn't allow this functionality. Anyone have any ideas how I can work around…
-
count an instructor only if last name is different
We send instructors to teach globally. I need to keep count of instructors on the field, quarterly. Sometimes 1 instructor goes to teach 2 courses. So the count would be 1 instructor, 2 courses. Sometimes 2 instructors go to teach 2 courses. So that count would be 2 instructors, 2 courses. This formula seems to work where…
-
Managing Resources across multiple projects
Hi All, We have many concurrent projects running at all times. I am looking for ways to manage resource assignments across multiple projects. When I assign a resource for a specific project/task, I want to see if this particular resource is available around those specific dates. Also, I would like to see the global view…
-
URL method to send information directly into a Smartsheet?
(Total noob with SmartSheets) I’m using Smartsheet URLs in an LMS training course at the end for feedback and suggestions. Currently we construct the link inside the course and it opens a web form when clicked with some of the fields pre-filled in based on user info from our LMS. It’s good to insure they don't have to type…