-
COUNTIFS formula help please
Can't figure out why this isn't working. I get #Incorrect Arguement =COUNTIFS([1 Weeks Tasks]$2:[8 Weeks Tasks]$100, =1, [Task Owner]:[Task Owner], ="Copyedit") I'm trying to get a count of how many '1''s in the designated row/columns (1 Weeks Tasks:8 Weeks Tasks) AND if Task Owner is Copyedit. The trick , I think, is that…
-
COUNTIFS Referencing Other Sheets
Needing help with the COUNTIFS and referencing other sheets. It keeps coming back #unparseable I am trying to find the number of projects in a certain phase based on who the project is assigned to. Active Leads Range 11: Assigned to Active Leads range 10: Phase . =COUNTIFS({Active Leads Range 11}:{Active Leads Range 11},…
-
Referencing Sheet using three attributes / one being NOT EQUAL TO
Hello - am am running a VLOOKUP to 1 sheet, and currently pulling 2 attributes, which works. (see below) =COUNTIFS({Function}, "Category Management", {Period}, "S-Cl", {Status}" I want to pull the Function name (above), a Period (above) and avoid pulling any Status that equals, Complete. I can't seem to locate the right…
-
If Cells not blank equal max date
I have a sheet with 7 columns that have dates (was checkboxes but could not get it to work) I want an 8th column to populate the max date from the 7 columns ONLY if all columns have a date entered. Basically I am tracking when people submit multiple documents, once all are submitted (i.e all dates entered) I issue them a…
-
COUNTIFS OR Function Error
Hi, I'm attempting to create a formula that will count the number of requests that are pending review. The column uses a drop down menu with three options, Submitted, Approved, or Declined. I'm trying to create a count in the Sheet Summary to count the number of requests that are still pending approval. The options that it…
-
Average Number of Bids and Average Bid Price per Unique Bid ID
Hi, I'm trying to get the average number of bids submitted as well as the average bid price per unique bid number. Can someone please help me with this formula? The bid numbers will sometimes have letters in them so they won't always be only numerical. Thank you,
-
Automate Harvey Balls Based on Date in a Column
Hello, This may have been asked previously however I cannot seem to find my specific request that only reference if a date is entered (not range related) so here goes. I have a Status column on a sheet and have it set to symbol: Harvey Balls. What I would like the sheet to do is to automatically insert the correct Harvey…
-
Need Formula Help - Dates and Check Boxes
I am trying to come up with a formula to count the number of items with any date within the month of January 2020 and have a box checked. I was able to figure out the formula to get the total count of items within the month of January 2020 using this: =COUNTIFS([Permit Start Date]:[Permit Start Date], IFERROR(MONTH(@cell),…
-
Using IF/AND with INDEX/MATCH
Hello - I have multiple sheets set up to feed into 1 result set and am trying to find a way to pull information from the result set into a table, if the criteria is met. Here is what I have, however, I keep getting #INVALID OPERATION. =IF({BCOA Range 11} = "YES", AND({BCOA Range 10} = "LCB", INDEX({BCOA Range 12},…
-
Formula that will add 1 to a Qty row
Newbie to Smartsheet...I am wanting to write a formula that would at a quantity of 1 if the prior column has a date in the cell. I am trying to calculate the # of installations. basically if a date is entered into an install date column, I need the formula to add a quantity to a install quantity column. thanks, sGF
