-
Transfer Sheet and Report Ownership While Keeping in Same Folders
An employee retired without transferring his sheets and reports, that are in various workspaces and folders, to me. How do I keep the sheets and reports in the same workspace and folders while transferring ownership to me? I'm SysAdm and licensed user on Enterprise account.
-
Saving Sheet changes
Hi everyone, someone on my team brought this to my attention and i want to see if anyone else has experienced this. I have a sheet where the 90% of the data is entered via a form. the remaining 10% of data is filled in afterwards once some additional information is received. my team member says that he is 1000% certain he…
-
Count days between start and end date
I want to show count of days between start date and end date
-
Tags (possible feature request)
Hi, is there any way to tag rows? I can use a dropdown list, but that only allows for one "tag" per row. I could also use a comma-seperated list, but without autocomplete and/or tag-management it's a very error-prone approach. All feedback is much appreciated!
-
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…
