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…
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…
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?
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…
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…
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?
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
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…
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…
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?