-
Need help with a formula that will pull info from 2 sheets.
Hi, I have my comprehensive sheet. Its currently pulling status info from a photography sheet. When photography is done with a project (each project has its own row), the project(row) gets archived to another sheet. When achieve, the current status of the project is no longer on the comprehensive sheet. So currently I can…
-
What formula could I use to nest automatically based on primary column?
Hello, Trying to make it so that information in columns b-f automatically nest under the names in column a instead of doing it manually as I have a large amount of data. For example, John Doe has a badge with two different types of access. I need those to nest under them while John Smith's access information nests under…
-
Project Management Plan - Schedule Health Formula
Hello, I looking to apply a formula to my Project Management plan whereby a color is assigned to each row given the "% Complete" and the "Start Date" "Finish Date". I want the health of the children rows to roll up into the Health of the parent row. I've used one of the templates with a built-in formula, however it does…
-
Formula trouble: Average score for specific word in multi-select column
I have scrubbed the community board for this answer, but was unable to find the formula I needed. Therefore I am sending out an SOS. :) On the master sheet, I am calculating scores and an overall total average. Example formula: =AVERAGEIF([NE: Value]:[NE: Value], <>"") -- This is working On my metrics sheet, I would like…
-
Tracking stages
We have stages in client on boarding and we would like to track the stages automatically, I want to track the stages by weeks for example client 1 stage 1 happened in week 1 and stage 2 happened in week 2 is there a way or work around to track the stages?
-
Sheet with Single Row needs formula across the row?
I have a sheet of indicators that pulls info from another sheet to process the correct indicator. I now need to set an overall status in the same row from the other indicators Here is the sheet and it will always look like this just one row So the second column Program needs to have a formula that looks at all the other…
-
Pull latest date of a task from a Task Sheet to a Latest Contacted Sheet
Hi community! I'm trying to find a way to have two sheets linked together. 1st Sheet: "Task Dump" where I can input the day-to-day tasks & notes after chatting with customers. Columns: Customer Name | Date | Type of Task | Action Items | Addtl. Notes 2nd Sheet: Pulls in the latest contacted date, type of task, action…
-
Index Match formula work around for Dynamic View
Hello, I am trying to find a solution for a sheet that has multiple lines with the same store#'s and inventory on multiple rows. This is not a shared sheet to our group, so I want to be able to index match this information to another sheet so we can use the info for internal purposes. I dont have the knowledge of how to…
-
Comparing Dates
Hi, I have a Planned Date and Actual Date and Final Date column. I need formula where Final Date column, has Actual Date, but when Actual Date is blank Final Date should have Planned Date. Planned Date | Actual Date | Any help is much appreciated! Thank you!
-
Total Payment monthly breakdown based on Start and End Date Columns
Hi Everyone, I need some support with a formula, if anyone can help me 😁 I have the below sheet where I have created costing for resource use between a Start and End Date Column supported by a total day column count between the two dates and use a day rate column to multiply the total column. What I would like now to do,…