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 …
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 Increa…
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…
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. …
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 th…
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" Con…
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)…
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "current…
When will we have the ability to VLOOKUP a value on another sheet? I link to a cell in another sheet now when the location is static....but in this situation the value is not in a certain cell.