-
Harvey Ball formula that reads across and produces cumulative
Hi All - I would like a formula that reads across vs vertically - here is my vertical one. I need the same thing but read about 10 columns status to then come up with an overall status meaning if there is 1 red, 7 yellow and 2 green then the overall cumulative status is red (lowest common denominator) Vertical Formula:…
-
Is there a way to use SumIF to add values in a column that match a specific text string in adjacent
We are building estimate sheets using a hierarchy based on Construction Specifications Institute's organizational coding system. I have rows nested using multiple parent / children. The top level is the CSI Division, which has children rows with specific categories within that Division, and each Category line has nested…
-
Mandatory Fields
Is there a way to make "Send me a copy of my responses" mandatory/a required field?
-
NETDAYS based on IF statement
I'm trying to use a NETDAYS function to determine how many days overdue a payment is, but I only want to display that number of days if a column named 'Status' has the value 'Client payment pending'. The function I'm trying to use is =NETDAYS([Date Sent to AP/CR]398, TODAY()) but I don't know how to work that into a…
-
Convert multiple text dates to a date field in a single cell
I have contract information entered into my sheet via Web Form. The users are allowed to enter multiple products in at once but asked to keep information pertaining to them in the same sequential order throughout the form entry. I am looking to see if it’s possible to take multiple text dates entered in a single cell and…
-
SUMIFS - Contains value in cell from another sheet
Hi All, I want to create a "Total Vendor Paid Amount" column on our "Main Dashboard". This column will need a formula that pulls information from another dashboard called "REO Vendor Invoicing (3)". I want the formula to sum the total invoices paid, in the "REO Vendor Invoicing (3)" dashboard, of jobs that contain a cell…
-
Limited Access to Report Builder
We have been using a very simple report to pull information from a single sheet. The report has been working fine for several months. Today I was notified (& verified) that I am the only person who can still edit the report via report builder. Everyone else is stuck viewing the information I last searched for and cannot…
-
Dependencies on GANTT view
Hi, I am struggling to get sub tasks report as I think they should. Example in screenshot. Basically, if I have sub tasks, then I want to have the heading task report the last date when ALL the tasks are complete. At the moment, by default, the main task shows when ANY date is entered in "Finish" which if sub tasks are…
-
Unparseable Error
I am trying to create a formula that will return different values based on multiple factors, and the information on the sheet is linked in from another sheet my sheet is attached and the formula I am trying to use is below. Any help is greatly appreciated Here is my formula =IF([% Complete]1 = 1, "complete",),if(and([%…
-
What's wrong with my RYGB formula?
Ok, I'm feeling really stumped. I have this formula for changing the color of the RYGB balls based on the number in a specific cell but it is returning an #INVALIDOPERATION on anything except zero (when the ball turns blue). Where am I messing this up? =IF([# of Days from Submission to Assignment]@row = 0, "Blue", IF([# of…