-
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…
-
Using multiple filters within one sheet
I am using a sheet as an employee resources database for links, training, graphics, documents, etc. since there are currently 400+ items in this sheet I started creating filters to help employees navigate specifically what they are looking for. Currently the only way I have found to do multiple conditions to a filter was…
-
Reports sort dropdown columns differently than a regular sheet
I have a sheet with a dropdown column for priority: High, Medium, Low. My sheet sorts them according to the order specified: High, Medium, Low. However, my report sorts them alphabetically: High, Low, Medium. Am I doing something wrong?
-
Contact List Drop Downs
Hi all, We have contact columns that we are trying to add hundreds of contacts too. The number is not above the limit specified by Smartsheet that I found; however, names continuously disappear. For example, User A may be able to drop-down and select John Doe as the main contact, but User B can't even see John Doe as an…
-
Either/Or Dependencies?
I want to be able to use a dependency like "either/or" instead of "and" ie: Task 3 can start after either Task 1 or Task 2 is finished, but does not require both tasks to be done. Is this possible?
-
Drop-down list
I have a drop-down list of names on my sheet. I need to remove one of the names and add a new name, but I want to keep the list in alphabetical order. I can't find a way to re-order the names in the dialog box where I add the new name. Does this mean I have to go back, delete all, and then re-enter the names, placing the…