-
formula help - sum if blank
I'm trying to run a formula to sum the numbers in a netdays row if another column is blank and am running into issues. Here is the formula that I have: =SUMIFS([Requested - Complete]81:[Requested - Complete]452, Q81:Q452, "1", [Survey Required]81:[Survey Required]452, "") Any help on what I am missing would be appreciated.
-
IF Statement to set a symbol to a value - #Incorrect Argument set
Good Day, I am trying to set a Symbol value using this IF statement but I get a "#Incorrect argument Set =IF([Prev Year Difference]3, =0, "Unchanged", IF([Prev Year Difference]3, <0, "Up", "Down")) The column/cell that I am using the formula in is defined as a "Symbol" using the "3 Direction" Up, Down & Unchanged. See…
-
COUNTIF and Multi-Select
Hello all, Here is a sheet with examples of how to use a COUNTIF formula the release of Multi Select. Hope it helps! Best, Kara
-
Cross Sheet Reference/ sum values
Looking to VLOOKUP into one data sheet to find - a sales rep name where the sales stage is contracted and sum up the Estimated Value field, which sums up any dollar amount in the (estimated value) field. End result is to show a sales rep and how much they have contracted to close via a dollar amount. My formula example:…
-
Use "Created By" auto generated field as a "contact list" for use with approval workflow
I have a form that is use to submit travel requests. I would like to set-up an auto-field that captures who the form was "created by", rather than having them enter their name into the "contact list". I was hoping to use this to then send an auto-generated workflow to this contact. However, I believe workflows only work…
-
Countif on Checkbox column type
Hi, I am trying to get the % of tasks complete. The column is a checkbox type. This allows me to get the number as long as all columns are 1 (checked) or 0 (unchecked) =ROUND(100 * (COUNTIFS(ES2:ES36, 1) / COUNT(ES2:ES36))) + "%" I need to add a Count if ES2:ES36 contains only 1 or 0, so if the column is set to N/A then…
-
SUMIFS with Multiple Criteria
Hi, I am trying to create a summary formula for Work-in-Progress (WIP) value on a KPI summary sheet, using data on a secondary sheet. I need the formula to do the following: * Only look up values that have a WIP% figure greater than 0 * If a WIP% figure is available, divide the total value by the WIP% * Add all of these…
-
Formula value
Hi, I have a job file that uses several VLOOKUP formulas to extract customer information, order and delivery date. When the task is finished I would like the information retrieved wirt the formulas to be embed in the task document so the task file can stop looking for the information. I currently use the Paste special but…
-
Insert row does not auto-fill
I thought this worked before, but maybe I am mistaken. When I insert a row (using the right-click menu, the row drop down, or the insert key), the formula from above and below the new row do not auto-fill. I really don't remember seeing that before. Craig
-
Where is referenced field
Ok, first, I took over this sheet, report, dashboard from a former employee and out of nowhere a sheet stopped working. I know the problem, just trying to determine how this happened and how I can fix it. There is a cell with a formula. The formula references a field in some other sheet. How can I determine where it is? If…