-
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…
-
Check box for parent row only
I have a sheet where there is a helper column that says either Parent or Child. If the helper states "Parent", I want the checkbox in a column named "Report" to be checked. Otherwise (if the Helper states "Child") I want the checkbox in the "Report" column to be unchecked. Can this be done with a formula or conditional…
-
How to create if/then formula to identify differences in text columns
I'm trying to automatically identify whether PIs in my departments are collaborating on various projects. I'm essentially looking for a formula that will identify in a column when up to 4 departments are not equal. Suggestions?
-
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
