-
Add 3mth date increment to 'date completed'
Hello, i'm hoping someone can assist me with a formula that i'm entering which returns an invalid error. I have scoured the help forum for assistance, but not had any luck replicating the formulas in my sheet. What i want to do is automatically generate a date which is 3mths after the date entered in the 'date completed'…
-
How to exclude a column formula on certain rows in a specific status
I am trying to capture when requests are on time vs past due in the 'Current Status' Column, and also trying to capture how many days since a request was submitted in the 'Days since Req Created'. I have those formulas figured out. However, I don't want those to run when the 'progress' is completed. So how do I add that in…
-
IF statement - Less than 3 weeks from today
Hello, I am looking for help on a formula for IF([Proposed Effective Date]@row is less than 3 weeks from today display "Rejected" AND IF([Have you received quotes form competitors?] = Yes then display "Rejected" So if one condition applies it displays "Rejected" or if both then "Rejected" displays as well. Thank you so…
-
Matching Neighbor Cells or Rows to Most Recent Date
Hey All, Background: Im trying to build a fluid dashboard that tracks information coming in from a form. This form is then routed to several sheets where I break it down further based on certain criteria. I am looking for a way to report on the most recent metrics in the given sheet using the sheet summary feature to make…
-
CountIfs with Distinct and a date range
I am sure it is doable, but I continue to struggle to get CountIFS, AND, and DISTINCT to work together. I need to count distinct dates in a long column and need to determine how many distinct dates there were in particular months. I'm able to use this to see distinct counts after a certain date:…
-
COUNTIFS IS BLANK OR other criteria
Hi all, I'm trying to make this formula COUNTIF the Due Date column is in the past and IF status column is blank OR it is "not received" =IF(ISBLANK(Status@row), COUNTIF([Date Due]@row < TODAY(), 1), IF(Status@row = "Not Received", COUNTIF([Date Due]@row < TODAY(), 1))) The above formula is returning 1, but the Due Date…
-
IF Statement for multiple cells with blanks
I am trying to create an IF statement which returns a status based on the status of 6 separate cells. How do I set the status to ignore blanks from those reference cells? For the attached example, the status should be set to "Not Started" based on the columns highlighted in blue.
-
How can I create a sheet that counts occurrences of a word in multiple sheets?
I would like to create a sheet that tallies up all the instances of certain words, such as 'retain', 'rotate', 'textile', etc., from multiple sheets. So it would look like: Retain - 30 Rotate - 50 Textile - 20 etc. Is this possible?
-
CountIf with Date range
I am trying to count the number of requests types between a date range. This is what I thought would work: =COUNTIF(({Request Tracker Range 4 - Request Type}, Category5), AND({Request Tracker Range 3 - Date Requested}, DATE(2019, 01, 02:2019, 03, 14))) I am using this formula to count the entire column =COUNTIF(({Request…
-
Complex JOIN(COLLECT())
Hello all, I'm hoping to use a formula to return a JOINED list of shared USERS for all sheets in Sheet 1. I have three additional sheets that contain all the supporting data, but since I don't want group names, is it possible to perform the user lookups from the groups sheet within the COLLECT function? Sheet 1: A list of…
