-
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
-
How to import filtered data range [not one cell value] from another sheet and display the range?
Hi all, Is there any formula so that from a master data sheet I can filter that data on a condition and display the full range that match the condition to another sheet? I can do this by generating reports. But I need to create a grid sheet where the filtered data range will be used along with some other things. In Google…
-
Change column cells based on different column input
Hi, I'm trying to create a formula that will change a cell in a particular column if the value in another column is Yes or No. For example, I have a column of statuses and another column confirming if it's an issue or not. If the issue column says Yes, I want the cell in that row in the status column to say Assigned. Been…
-
How do I get an average based on given month?
Trying to get the average of [Page Views] for a given month [Last Activity]. Averaging the Total Page Views for the month of September The following returns invalid data type... =AVG(COLLECT([Total Views]4:[Total Views]55, [Last Activity]4:[Last Activity]55, =MONTH(9))) My assumption is that the test for the given month is…
-
exclude blank date in At Risk column
I need to edit this formula to add in an exclusion of blank dates in the "End Date" column. Suggestions welcome! =IF(AND(OR(Status@row = "Red", Status@row = "Yellow"), [End Date]@row < TODAY()), 1, 0)
