-
Cross-Sheet References with Contacts
I don't know if what I'm trying to do is not possible within the application or if I'm just missing something. I have created a form that the user selects their name from on the dropdown list. On the corresponding sheet, I'd like to populate their email address and office code by using a master contact list in a different…
-
Transferring ownership
Hello! I am an admin at workspace of the company. I can't take ownership of sheets from an existing user with business license. I have this message when trying to get ownership: You cannot take ownership of this item because the current user is not in your organization. Can you please help to solve this problem?
-
Can you create a master project plan with rollup plans below?
I need to create multiple project plans with one resource in common so I want to make tasks between the plans dependent on eachother so that the engineer doesn't have overlapping work and if one task is delayed it will impact the other projects. Is this possible? I don't want to run a report because I won't be able to add…
-
Can you create a Sheet Rollup of all open actions from each project owners sheets?
What about a sheet to roll up all open tasks of each project owners sheets so a managed worked flow to request updates would include all updates needed for all the project owners sheet actions? This way they are not getting a lot of separate emails for updates on each sheet.
-
Sheet Summary
Hi, When copying a sheet summary to other sheets within the same workspace, it carries the field names but not always the information within the field. For example, after having copied the sheet Summary, the "Completion %" shows =[% Complete]30 + " %" or #UNPARSEABLE, instead of an actual number, ie. 50 %. There's no…
-
Changing Drop Down Value Based On Current Date?
I am trying to change the drop down value on my Health column based on the current date. Is this possible? ie. If the start date value is in the past, the health column changes to "At Risk" which is one of the drop down choices.
-
Nested If Formula
Hello, I am trying to create a nested IF formula based on the criteria below. Below is also a screenshot of what I am trying to do: =IF([% Complete]1=0,"Not started" =IF([% Complete]1>=0 and <=1, "On track" <code class="CodeInline">=IF([%Complete)]1=1,"Completed" =IF([%Complete)]1<=1 and Due Date is past,…
-
Creating forms
I would like to know if it's possible to create a form template associated with a Smartsheet. The purpose of this form would be to collect requirements for a request that a client enters into a Smartsheet. The client would access template, complete the fields, save it, and then attach it to a specific line item in the…
-
System Column - Last Modified
Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the…
-
Any way to display task names on a Resource View
I want to be able to see a view of all my staff with their associated tasks across all projects. Currently the Resource View does this except it does not label the tasks, it simple shows allocation percentage. Is there any way to get those items that simply list as percentages to show the actual task name? Or is there any…