-
Alert when a row has not been updated in the last 14 days
A project lead has requested an alert that sends to him when a row (assigned to a project manager) has not been updated in the last 14 days. My attemtps at a solution: 1: Include the system column (Modified - Date) 2: Trying to apply conditional formatting to make it easily visible when viewing 3: Can't seem to work out…
-
Counting Number of Times a Predecessor is Used
Hi, Long story behind this one, I'll try to keep it short. On Smartsheet, the critical path tool isn't working for my sheet because our project has too many hard deadlines and we are not using enough predecessors; however, we need to be able to view a critical path, so I have accepted that I will have to create one…
-
Universal Conditional Formatting Across All Sheets
Hi, Is there way to have a conditinal format rule apply across an entire database? For exampe, i have a collegue whose name I want to highlight in yellow so it it easy to see on any project (sheet) he is working on. I want to avoid adding the conditional formatting rule to each sheet he appears on. Is it possible to make…
-
More A-Z Sort options.
Is it possible to add more sorting options. right now we only have three drop down bars, I need four. How can I add more?
-
Updated cells automatically highting in Pink
Is there anyway to stop updated cells being highlighted in pink for 1 hour after they have been updated? THe reason being is because whilst it is pink it is not possible to update the cell colour to anything else which is fustrating. woudl appreciate some help on this brook
-
Conditional formatting based on the current date?
Hi, I'd like to highlight tasks (specifically the Start date cell) a color when that date is less than the current date (today) and Completion is 0% or null. In other words, which tasks were supposed to start but have not yet started. I realize this is a complex condition that uses two fields but it would be helpful as a…
-
Project light status, Entire Row format & due date
Hi: what would be the formula for the following: project light status | Start Date | Proposed finish date | Finish date | Complete G 1/1/2015 2/10/2015 2/10/2015 complete R 15/1/2015 2/10/2015 3/15/2015 overdue/ At risk in both cases, Start date is pedecessaor to Proposed finish date and Finish date. So when we have a…
-
Iterative process
Hi has anyone figured out how to perform an iterative process in smartsheet? I am trying to manage a construction budget through smart sheet and need to be able to use several iterative processes to get the correct total contract dollar amount. Thanks Doug
-
Done colomn
I want to know if this is possible. When the DONE colomn is checked, can it move itself to bottom of the sheet?
-
Is it possible to conditionally format a row based on the status of it's dependencies?
Hi, I'd like to colour a row, or perhaps set a column based on the status of that rows dependencies. Does anyone know if this is possible? Thanks in advance, Tom
