-
% Calculations On children
HI Community I have A Quick Question On % Calculations I have a Payment Sechdule Which has a a main Name For example Wall Framing Under Wall Framing i have indent Wall framing on Floor 1, Floor 2 etc, And i ran =SUM(CHILDREN()) To calculate Total We charge on Wall framing Now For my customer i want to send only The Main…
-
Counting rows with multiple drop-down options
Hello, I would like to count all the rows on a sheet that meets certain criteria. The sheet has a column [Project Status] with the following drop down items: Tentative Confirmed In Process Delayed On Hold Punch List Completed Cancelled RMA Processing I would like to get a total count of all the rows that have open…
-
Find the Max and Min value in a column
Hi, I have a sheet with a single column that has a large range of numbers. I would like to use conditional formatting to highlight the highest number and the lowest number within this column so its easy to see when viewing the sheet. I can use the functions Max() and Min() to find the highest and lowest values, but these…
-
LOOKUP function - I cannot find any info on how it is supposed to work
Hi, I have read some threads but I am still not clear on how LOOKUP is supposed to work. I know it cannot function across sheets. But please can someone provide the syntax and basic data? Thanks, Ele
-
Compare text in two different columns
I have a large SS that includes two rows of columns...one is the listing of the latest print revision, and I want to compare it to another column reporting which revision the part was actually built to. Both of these columns are populated with a letter (NC, A, B....AZ). My goal is a Conditional format color if the two…
-
Triggering a notification based on the dates of two rows
I would like to create a notification to let me know a task will be finishing late, which will impact the start of another. IF the 'Finish Date' of task 'Narrative' is greater than the "Start Date' of task 'Review' send notification You can see in the screen shot that Hillary is going to be impacted on starting her work…
-
How do I count new rows from web forms?
Hello, I'm trying to count new rows that come in on a web form below a specific row using a formula. How do I start my formula range on a specific row, then count all new rows that are below it as they come in from the webform? We use a webform to receive quotes from subcontractors. As they come in, they are moved up to be…
-
index and Match
Hi Community Im having an issue with index and match 4 i have imported from Excel the sheet is set as follows Item Name Vendor name 1 vendor rate 2 etc, Example Item #102 Rate on vendor 1 20.00 rate on vendor 2 25.00 then i have a coulmn calculating the best price =min on vendor 1-vendor 2 and by best name i want it to…
-
% complete manipulation
Is it possible to have a second % complete column that somewho only shows what % of work for child tasks that have a start date that is <= Today. So basically I want to know what % of work is complete that should have already started. I would only use this formula on the top level parent row of the whole project and it…
-
Formula for pulling Start and Finish from cell
Is there a way to pull Start and Finish data from a cell that has both? I'm importing a spreadsheet schedule with cells that have both dates expressing a date range, eg. "2/1 - 2/7"
