-
Error on Index/Match Formula
Can someone PLEASE tell me what is going on with my formula? I'm trying to do a simple index match and it's giving me an error message: However, I have confirmed that the session codes that I'm matching on are present in the sheet that I'm using to cross reference. The only thing I could think of as to why it's not working…
-
IF((CONTAINS)) function
I'm trying to verify that the emails in a column have the correct spelling. I'm using an IF((CONTAINS)) function, but it's not working =IF(CONTAINS("@kintegra .org", EMAIL@row ), "", "Check eMail")
-
Health Ripple Effect Formula
On my project plans, I use a Red/Yellow/Green/Gray column called [Health], and I also use the stock [Predecessors] column. I'm trying to come up with a column formula so that if I change the [Health] value on a given row, it will update the [Health]@row value of every row downstream that directly or indirectly uses the…
-
Formulas
If you have different numbers per line in the barcode column, you can see which product it actually is from these numbers. For example, 9040005530102: from the first two digits, you know that this product is DIM90. In the same barcode column, after scanning, you may also see other numbers such as 10040005590117, which is…
-
Added 2 years to date, only want to populate in specific fields
I have created a calculation to add 2 years to a specific date listed in a field, but I would like to create a formula where it calculates the 2 year date but only populates if the other field is filled in. Current formula: =DATE(YEAR([PO Date]@row ) + 2, MONTH([PO Date]@row ), DAY([PO Date]@row )) If the PO date is fill…
-
JOIN/COLLECT - Order by most recent
I’ve configured a Smartsheet process—fed by Data Shuttle—that supports multiple activity rows per consumer. Each row calculates a unique Row ID and helper flags (Occurrences, Duplicate Entry, Duplicate IDs) and builds a Detail Key that concatenates Item, Supply Count, Date, and Person. Using these helpers, the sheet joins…
-
Creating data to populate a dashboard
Hi all, I want to display a count of a particular item from 1 column (dropdown with multiple options) but need it to also cross reference another column (dropdown with multiple options). So example is if first column (Site) is "Preston" and second column (Contact) is "Warehouse" then give me a count of this combination.…
-
Sum(Children()) Formula Issue
My sum(children()) formula in the first row is resulting into zero. Idk why although I tried to double check that the numbers are formatted correctly. any assistance is appreciated.
-
COUNTIFS & ISDATE FORMULA
Good Afternoon, Hope you are safe in this winter weather. MY FORMULA is unparseable: =COUNTIFS([DEACTIVATE TIMESTAMP YR 5]:[DEACTIVATE TIMESTAMP YR 5], ISDATE(@cell ), [Abbreviated Org Name.]:[Abbreviated Org Name.], "CHARM")) The formula should count ONLY if any date is appears in column DEACTIVATE TIMESTAMP YR 5 = ANY…
-
How to Phrase a Question for the AI or Write the Formula for Myself for Grouping Data
Hello, I would like to see if anyone can help me parse entries across different columns. What I have in my SS is a list of registration numbers in Column A and departmental associations in Column B. I would like to count how many different registration numbers appear in Column A and then group them by their departments in…