-
Nested IF Formula
I would like the IF statement to return a specified value if based upon date ranges. For example, if a date falls within a range: 09/01/23 - 11/30/23 should return the value "Q1" 12/01/23 - 02/29/24 should return the value "Q2" 03/01/24 - 05/31/24 should return the value "Q3" 06/01/24 - 08/31/24 should return the value…
-
RAID Log Date Value Locking per column when status changes
Hello everyone, I have tried to find the best answer for this but I see too many threads and different responses. If anyone could help as I am new to this. I am only looking to lock in a date value on 2 columns whenever there is a status change, from when an issue is raised and then resolved. I know there is a record a…
-
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.
