-
Applying a formula for the whole column
Hi! I currently have a formula for a specific cell in a row. I would like to apply that formula to all cells in the same column. I tried dragging the formula down as far as I can go, but when a new row is added from a form, it seems to add way down my sheet (not consecutively after the last entry) and the formula is not…
-
Looking for Help / Guidance
Greetings, Looking to do something extremely simple but just cannot get it done. Hoping that the folks in this community can assist. I have 2 sheets. See below. Sheet A: Sheet B: All I am trying to do is .. in Sheet A ... Value of License Used for Customer Number (1234) be the Sum of all the same Customer Number ("1234")…
-
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…
