-
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…
-
Delete multiple conditional formatting rules simultaneously
Is there a way to delete multiple conditional formatting rules at once? I have over 100, and 40 different sheets to delete them on. Is there a better way than just clicking through and deleting one by one?
-
Solution for extreme amount of conditional formattting
Hello!!! I have a scenario that has an extreme amount of conditional formatting requirements. if completed, the sheet will have over 10,000 conditional formatting rules. While hear there are not limits to the amount of rules, at 1,800 the conditional formatting dialogue box really doesn't want to open any more. Has anyone…
-
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…
