-
Sheet changes biweekly
Hi all, I have a sheet that goes out biweekly for vendors to update and make changes on sheet. I am looking to create a line chart that measures bi weekly changes (if any). There is really no status column to measure which would be easy to measure changes, it is overall changes to sheet, if any. Thanks in advance!
-
Formula not working
I'm trying to add a column that indicates if a line item is urgent or not. Urgent meaning the due date is past or within the next 5 days. The formula I am using is =(cell with due date)<=TODAY(5) I keep getting an error message #INVALUD COLUMN VALUE. My column type is set to text/number.
-
Need to Create Separate Opens List from Data Sheet
Summary: I have a data sheet with a primary column listing different equipment items. Going across, there are a number of columns, 15 of which have drop downs with options N, N/A, Y, and Open Item... I need to populate a list, to a different sheet, showing only the columns, where that piece of equipment shows, Open Item.…
-
Capture Snapshot of Linked Cell at a point in time
I would like to capture the value of my Current Launch Timing (QC Release) when projects are submitted for Gate 4 automatically. Both columns are Date columns. Current Launch Timing (QC Release) is currently linked to the project plan. I don't want the value to continually update as the timeline updates. There doesn't…
-
COUNTIFS, within a month AND not blank
I'm really struggling with countifs in my Sheet Summary. I added a helper column to sparse the month. I want to count if the created date is February, and if two columns containing IDs are not blank. =COUNTIFS([Month]:[Month], = 2,[Contact ID]:[Contact ID 2],""<>) I'm getting an #UNPARSEABLE error. I tried the formulas as…
-
Sheet Summary Formula Not Pulling All Data
Hello, I have a formula set to count how many projects are flagged within a specific function if they are listed as in progress, but the count is off and I can't figure out why it's not counting all instances. Is it because the column is allowing multiple selections in that column?
-
Unique Count with Multiple Criteria
Hello. I am looking to count the total number of encounters by month within each specified postal code and am unsure of the formula to use. I have tried countifs, distinct, collect etc.. and am not getting the results I had hoped for. I have attached a picture of the data I am hoping to summarize What formula do you…
-
Formula Issue - Email Addresses
Hello, I am running into an issue of automations and triggers not working because of multiple email addresses in a cell. As you will see in the Dashboard screenshot attached, rows 2 and 3 that have one email address listed under the "College/Department Designee Email" column is leading to all appropriate workflow actions -…
-
Formula for counting multiple cells
Hello, I am struggling with formulas on my calculation sheet that references my main sheet. In the example below, I am trying to count every time my name appears (which could be in several different columns) if one column has a certain activity selected (in the example below this is "internal customer engagement". Can…
-
#INVALID DATA TYPE
Hi Im using the formula =IF(YEAR([Expected project completion date]@row) = 2024, WEEKNUMBER([Expected project completion date]@row), "") If the cell "expected completion date" is blank I get #INVALID DATA TYPE. is there a way to remove this and just have the cell blank? Thanks