-
Master build schedule to sync with other sheets?
I am not having any luck searching for a solution to this. My company has a production schedule in Excel. It changes daily. Builds get added, removed and moved around on a regular basis. We have two different engineering departments that are managing their work load in Smartsheet. The two departments have very different…
-
symbols - words showing not colour
Hello please can someone help with formatting? I can't understand why the word Grey is showing rather than the symbol? I've selected the set for the 4 colours from the symbol menu for the status column and created the below formula =IF(Status15 = "Complete", "Green", IF(Status15 = "In Progress", "Yellow", IF(Status15 =…
-
Referencing column in another sheet from row 2 only
I am trying to set up a formula that counts the number of cells containing information in the first column on another sheet. I just don't want it to count the text that is in row 1 (ie I just want it to count from row 2 onwards as I am constantly adding data to column). I don't want the formula to even reference row 1 as…
-
Formula Help
I'm having trouble putting together a correct formula or workflow to do certain tasks. I have a rent tracker spreadsheet and want a formula to basically say "When it's 30 days prior to the Rent Increase Date then automatically turn the Status Column drop down to red. Once the Status Column drop down is changed to green…
-
Reference List of Dates in Column Relative Today
Hello! I have a project I am working on where I've created a little bit of a manual schedule that I'm integrating into a smarter excel sheet, but I'm struggling with a formula to duplicate information. I've attached a screenshot below of my spreadsheet... what I need to have happen is this: I would like to have a formula…
-
Use formula to create name of cross sheet range name in a VLOOKUP
Hi Folks, I have a master sheet that links to a work sheet for each row. There is a unique ID number on each row of the master sheet And each work sheet has a range named using that unique ID number. SO is there a way to look up the ID number in the row, and uee that number as part of the name of the range in the vlookup…
-
Cell link indicator
Hi everyone, Is there away to hide the cell link triangle indicators? Most of my cells are linked and it obscures the data. Thank you
-
assign child rows from parent row
I have multiple parent rows each with over 30 child rows. I would like my "Responsible Party" cell in in each child row to be populated if I assign it in the parent row. I.e. I would like to select the contact (Responsible Party)in the parent. I would then like for each child row under to automatically be assigned to the…
-
Cell Linking Within Same Sheet
Hello... is there a way to link the value of a text-based cell to other text-based cells within the same sheet? I have a project plan template in which there are several fields in my "Assigned To" Contact List column which will need to be populated with the same person. Instead of even copying/pasting, I was hoping to…
-
Resource Assignment based on a Vlookup?
I am creating templates for repeatable "projects." I would like to have a column of "Role Assigned" and set up a table (filled in when the template is used) that associates a specific person (Contact) with each role. Then in each row, a Vlookup would be used to automatically fill in the "Assigned To" contact name from the…
