-
Match all columns to complete
I have several columns with dropdown (Complete-Go, Incomplete, TM Approved-Go) and one column that says (Go/No Go). If all columns have "Complete-Go or TM Approved-Go" the column (Go/ No Go) should be "Go" If any column has "Incomplete" the column (Go/no Go) should be "No Go" I appreciate your help very much! Rob
-
How to put a value for each item in dropdown list
I have a dropdown list and I want to put a value for each item (but not in the list): Not Ordered = 0% complete Ready to Order = 1% complete Order Process = 20% Shipped = 50% complete In Country Customs = 80% complete Delivered = 100% complete Cancelled = 100% complete This is to help me to calculate the task % complete…
-
Conditional Formatting Duplicates
Hello, Is there a way to conditionally format duplicates if a value is in a column and if a box is checked? I need this to look through the whole sheet where there are many input values by the customer via a form. Thank you. Brian
-
How do I count the entries from a column from another smartsheet?
I need to count total entries from another column from another smartsheet minus out scope criteria. i.e. 1st Smartsheet, column 1 Title “Total Sites in Scope” 2nd Smartsheet, Column 1 Title “Site IDs” that has entries. Column 2 Title “Order Status” dropdown option “out of scope” Solution: 1st Smartsheet, column 1, cell 1…
-
How do I make the cell to change data after other cell is populated?
I have sheet 1 with the rows below with formula in: LAN Migration Ready =COUNTIF({sheet 2 name Range 10}) LAN Migration Ready Approved =COUNTIF({sheet 2 name Range 11}) LAN Migration Scheduled =COUNTIF({sheet 2 name Range 12}) LAN Migration Complete =COUNTIF({sheet 2 name Range 13}) Sheet 2 I have: Each row represents a…
-
Status Rollup to Parent
I've seen some very similar solutions to my problem, but not quite what I am looking for. My Smartsheet plan has a status column and is using dependencies. My choices in the status column are (Not Started, In Progress, At Risk, and Complete). I would like to create a formula that automatically rolls up the parent of each…
-
Process Steps with fixed start dates and predecessors
I have a project timeline that has a manufacturing step that is contracted to start on a specific date in the future. This manufacturing step has predecessors, but changes in the timing of the predecessors will not change the date of the start of manufacturing because there was enough lag time built into the schedule to…
-
How to identify the first date and last date from another smartsheet column?
I need to identify the following: Smartsheet 1, Column Start Date, row 1 cell 1 and Column End Date, row 1 cell 2 (need to obtain from smartsheet 2) Smartsheet 2, Column Start Date and Column End Date have several dates. Smartsheet 1 needs to identify the earliest Start Date and the latest End Date from these two columns…
-
RYG Arrow Colors
I would like to recommend an additional option to swap the red and green arrows so that there is an option for red arrow = up and green arrow = down. This is helpful for budgeting in project management where at a quick glance you can see if we saved money on an item or lost money.
-
How to check if Flag has been flagged in another sheet? Formula?
I have a metadata sheet that has At Risk row with a flag symbol, and I would like to check the other project sheet with an At risk column to see if any flag has been marked in that column. If any task has been marked in the project sheet, I would like the flag symbol in Metadata to turn red as well.
