-
Basic A/P and A/R payment tracker
We're a property management company with a construction arm. Our construction is basic and requires us simply to track Owner/Address/Date of approval/Job number (which we create)/Contractor's Bid/Change orders/Payments to Contractor/Balance to contractor/Our Bid/Change Orders/Payments to us/Balance due us/A/R for cash paid…
-
Check a box in the phase row, if all the tasks are complete
This should be easier but I'm struggling with it. If all the tasks are complete, indicated by check boxes, I want to automatically mark the phase complete. So, the box in black below should automatically check when the other boxes below it are all checked.
-
Can I use an if statement to return a numeric value based on red yellow green symbols
I am trying to create a scorecard and would like to return a numeric value based on symbols (green = 5, yellow = 3, red = 0). Is that possible? Formula help would be amazing!
-
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?
