-
Drop Down List Data Validation
My team and I are new to Smartsheet, and after 2 days of using the software, have already found a couple of major road blocks that will likely keep us from using Smartsheet. The biggest is the inability to create a drop down list that uses data validation to pull a list of options from another Sheet. (Example - one sheet…
-
Is it possible to set up conditional formatting to alert when a duplicate entry is inputted?
Is it possible to set up conditional formatting to highlight or alert someone if a duplicate entry is being inputted? I am looking to highlight the DOC ID if it has previously been entered into the sheet.
-
Conditional Formatting Not Working with Formula: change colour based on date
Hello everyone, I'm trying to conditionally change the background color of a date column based on if it is today or yesterday. It works just fine if I type in a date, but if the date is populated via formula then it doesn't work. I have tried disabling and re-enabling with no luck. The cell in question references 2 other…
-
Legal projects/task management sheet
Hi, I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce. To track the work, I have created one sheet for the legal team to use, covering all main "legal work" categories and then broken down to sub categories, tasks and then sub…
-
Is it possible to add a delay to a task if it doesn't have any predecessors ?
I have few tasks in my sheet, which are not independant of other tasks. The dependencies have been swtiches on in the gantt view. Is it possible to add a delay to these tasks without manually changing the dates ?
-
Color Coding In Progress Tasks within a Specific Time Period in Gantt Chart
Is there a way to color code tasks in a gantt chart that occur during a specific time period? For example, I would like all tasks that are in progress during the months of May, June and July to show as red. I see that I can set conditional formatting to fill the cell background of tasks with specific start and complete…
-
RYG Ball Automation
Hello, I am trying to automate RYG ball based on Y/N responses to other cells OR I could change the Y/N to also be RYG if that would make this possible. Essentially, my overall goal is to automate the RYG ball based on how 26 other fields are answered -- 13 or less are green = Red 14-19 Green = Yellow 20-26 Green = Green…
-
Date Last Updated?
Is there a formula I can use that would show the last date that a specific column was updated? For instance, when someone checks the checkbox column, could I have a formula in another column that would reflect the date the checkbox was checked? It wouldn't work to have a formula that showed when the entire row was last…
-
Baseline/Actual Schedule formula help
Hello all, I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additional rows with "Actual Start" and "Actual Finish". When I enter dates into those rows, I'm looking for them…
-
Improvement Feedback on Conditional Formatting
Hi All Please read my feedback on Conditional Formatting. I need your vote on how valuable this change would be! FEEDBACK The conditional formatting should allow us to create a condition --using another existing cell's reference. Example: If "Fee Collected" is less than "Fee Due" then apply this format to "Fee Collected".…
