-
How to trigger dropdown to populate projected completed date based on specific complexity?
I want to trigger these drop downs in the "Complexity" column to populate a date in the "Projected Complexity Completion" once a dropdown value is selected and once status changes to "active". Low Complexity = 2 days Medium Complexity = 5 days Most Complex = 10 days
-
Can you make a field required on a sheet?
Hello, We use a sheet for our HR departments. We want to have a field required to be filled out based on a drop-down menu selected. So if the status of the drop-down is HIRED, they should need to fill out who the direct Report is, so the data is complete. This is not on the form. This is directly on the sheet. Thanks in…
-
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.…