-
Can I use a formula to copy the date from my "Target Date" column to my "Projected Date" column?
I'm working on creating a project status dashboard to share with stakeholders at my company so they can easily understand where each project stands. I have a "Target Completion Date" column and a "Projected Completion Date" column. I'd like to be able to use a formula so that when the "Status" column says "In Progress, On…
-
Date Comparison Formula Help
I am a SmartSheet novice, but my team is used to base tracking in SmartSheet. I would like to set up conditional formatting that highlights if a site's planned schedule puts the site at risk. I would like to compare two columns: "Construction Schedule: Turnover to Retail Date" against "Exterior Installation: Scheduled…
-
Conditional Formatting Not Working
Hello, I've set my conditional formatting for rows marked "delivered." However nothing is happening. Any help on what step I may be missing is greatly appreciated. I've attached a screenshot for reference. Thank you.
-
Is it possible to restrict certain information within a sheet based on users?
I have admin access to a sheet that was created internally. There are other users that have access as well but I'd like to restrict certain information within the sheet to particular users. Is it possible to create a condition that will restrict certain information?
-
A Template that is more friendly way to set this up
I hope that my screenshot is helpful, but i am still using new tools in Smartsheets, but i was wondering if anyone had any idea of a way I can set up my 1x1 meetings, per supervisor in Smartsheets. So i have 3 departments, and each department has about 12 supervisors each, and those supervisors have about 12-18 employees…
-
Enable conditional formatting based on Critical Path items
When a row is on the critical path, I'd like to be able to set conditional formatting so that it turns text red, or colours the cells, so that it is a more obvious visual cue that this task is a particularly important one.
-
Conditional formatting in Gantt not working with dependencies
For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable dependencies, but I need those and don't understand why this should matter since I don't have any rules related to status or % complete in the…
-
Conditional Formatting Primary Column Indention
Is there any way to indent specific rows in the primary column that meet a specific condition, like through conditional formatting? For example, WBS ID is the Primary Column. I would like to indent that row if the Activity ID is not blank. It appears that the only way to do so is manually indenting/outdenting.
-
Join Formula with Dates - How to eliminate the time stamp?
I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted to only show the date, not a time, however when I use the join formula, it's giving me 'Task Name -- ##/##/## 8:00 AM - ##/##/## 4:59 PM" and I…
-
Conditional Formatting: Changing Cell Color Based on 3 Separate Date Ranges
Hello All, I'm trying to set up conditional formatting where colors change based on how many days they are away from an automatically generated reference date (Helper Column). Currently I have it set up so that in when the reference date is in 15 days, the "date certified" column will turn yellow, in 5 days it will turn…