-
Gantt Chart Colour - conditional formatting
Hello, I would like to have my gantt chart view coloured by the status colour. I don't want to have the whole row in e.g. green, only the task. I can do this by manually formatting the colour, but not automated, or at least I am unable to figure it out by myself. Is there a way of setting the auto-colour of the task bar to…
-
Conditional Formatting if Time is later than 5:00PM
I am using the TIME function in my Planned Start Time and Planned End Time. Planned End Time is calculated using the Minutes Duration column (=TIME([Planned Start Time]@row) + [Minutes Duration]@row). I want to set up conditional formatting to highlight times that are outside of business hours. I tried to set conditional…
-
Merged: Multi column formatting
This discussion has been merged.
-
Flagging a Date and Time Overlap
Hello, I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as many as 6 to 8 classes in a day, but only have 4 conference lines. I'm trying to write…
-
why does my conditional formats fail to function when the set conditions exist?
why does my conditional formats fail to function when the set conditions exist?
-
How to look across columns with checkbox data type to make them mutually exclusive?
I have 3 columns in my Project Plan that I am using to have team members fill in to indicate if their task is off track, on track, or complete. I only want them to be able to check one of the boxes. Is there a way to look across these 3 columns in a row to meet the following conditions: If Off track is checked, clear…
-
Smartsheets - Machine Learning or other solutions
I'm working on a large smartsheet log that intakes customer information. I am wondering if Smartsheet can do the following using AI/machine learning: Users Update cell, Read cell, Interpret cell, and automatically insert the appropriate option from a drop down menu based on what is interpreted. It needs to be able to learn…
-
Unable to get an avg percentage for some depends for a report
I created a summary report that shows percentages for each task under high-level management. The issue that I am having is when I summarize the percentage column using average. The high-level manager does have a percentage, instead has a NaN. The percentage column is an IF OR statement using quotes to hold the percentage.…
-
I need help with a formula or direction if a formula isn't the best way to go
In my sheet I have 4 different dates , requested, procurement, legal and council, and I want the status to change when each date is filled. So if status has a date I want the one quarter symbol, procurement the half symbol, legal 3/4 symbol and council full. can someone help?
-
Sorting in Card View
When I sort the sheet with conditional formatting it works fine. When I change to card view, it seems to lose some of the sorting. Any thoughts?