-
CHECK BOX IF TWO CELLS MET THE CRITERIA
Hello, as you can see, I have a form and if a employee selected a certain date and certain time, what is the formula to tick or check the box on the circled part of the picture. Please share with me the formula. Thank you
-
Delete or Clear all conditional formatting
It would be great to be able to check all the conditional formatting for a sheet to deactivate or delete. There have been times where a sheet has many activated or disabled that prohibits fields from being changed because they have a conditional formatting (this is awesome btw). If there were an option to delete all (or…
-
IF, AND, OR Functions
So i have two formulas , one works and one does not; hoping someone can see what i am missing here. i have four columns that i need to take into consideration before i automatically check a checkbox . using two of the conditions works; i add the third in the second example and it blows up. thanks in advance: works:…
-
Global Update for Conditional Formating?
We work with the control center, and we have 50 plus sheets of a template sheet. (we have approx 10 templates in the template) We need to change the conditional formatting due to a change in our drop-down lists. As of right now, we will have to do it on every sheet. This is tedious and prone to error. With the changing…
-
How do I auto populate subtasks dependent on a main ''Task Title'' selected from a drop down list?
Afternoon, Basically I have a smartsheet to track marketing tasks and subtasks. I have some tasks, where when selected I'd like a list of subtasks to auto populate on seperate rows underneath the main task (and indent as well if possible) I've tried using the INDEX (COLLECT) function where when a specific task is selected…
-
I have an excel sheet with at least 4 tabs, and i want to transition that over to Smartsheets
qqqCan anyone assist me in how i can do this, i know smartsheets doesnt include tabs. Below i will give an example. How can i make this reflect in Smartsheets, and as i get new associates, I would need to match them up to a shift? I hope that make sense. any assistance would help, thansk in advance.
-
Color code the cells
Hi All, I have a question regarding color coding the cells on Smartsheet. How can I color code column (Actual Delivery date) to highlight the following: Dark green : for when the Actual date is equale or less than Date committed Light Green : for when the Actual Date is after the date committed Red : for when Actual date…
-
How to prevent row data from shifting up a row?
We have a data sheet set up within SmartSheet (Sheet A) that feeds off our master sheet (Sheet B) that contains all of the current positions within our company. This automation is set up so whenever a new position is created in Sheet B, it'll auto-feed the position name into Sheet A into Column 28 of the screenshot. The…
-
Conditional formatting not working in a cell with a colomn formula
Hi - I have a colomn that has a vlookup formula and I want it to be blank if there is #NO MATCH. I used conditional formatting to make the background white and the text white - but it is not working. Here is the formula: And here is the conditional formatting: Any ideas if this can be fixed?
-
Can a Form have multiple entries and have them display as multiple lines on the smartsheet?
I have a form I'm using as a maintenance work order log. I have them fill out a form, which in turn fills out the order log. Is there a way to have them enter multiple parts and descriptions and have them populate on multiple lines in the smartsheet order log? If they do have to enter a form entry for every part they want…