- Assigning Colors to Contacts
I use the gantt charts and calendars to make sure my contractors are not in two places at once. Is there a way to color code each contractor so when I assign a task, it automatically shows in gantt and calendar view as the color assigned to them? I seem to have to do it to each individual task. Then the color coding doesnt…
- Week Numbers
How do I display a week number in a field, that references of a date field.
- New in Smartsheet: Gantt and Calendar Views on Reports, Better Update Requests, and More
Smartsheet’s newest improvements give you more power to choose the level of detail you want to share, both within and outside your organization. Send a project rollup to executives using Reports, now complete with Gantt and Calendar Views, or share a single row to an external collaborator for a quick status update with…
- 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
你好:什么是f的公式ollowing: 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…
