-
If Formula
I need help understanding why I keep getting #INVALID OPERATION with this formula. It only happens when I want to look at Audit Status. I know its a large formula but Im using it to check for missing items and notify the team on next steps. =IF( OR(ISBLANK([Profit Center]@row ), [Profit Center]@row = "⚠️ PROFIT CENTER NOT…
-
Conditional formatting for "where % complete is not equal to 1" is not working
I have a project plan where I'm trying to set conditional formatting where % Complete is not equal to 1 and Finish Date is in the past, to turn row Yellow. It is not working. Please advise.
-
Can anyone spot what is wring with this formula?
=IFERROR(IF(ISBLANK([C1D1 Date]@row ) = 0, IF(ISBLANK(INDEX(COLLECT({Patient ID}, {Visit Collection Date}, [C1D1 Date]@row , {Sample Name}, "PK PRE PRI", 1)) = 0, "Received")), "Not Received"))
-
Issues with the Subject line of automated messages from the Smartsheet
Hi, I recently automated using manage workflow where Smartsheet will automatically send out emails to specific group of people about a product delivery when a date criteria is met. The message looks like this Subject: Parts shipping on {{Delivery Date}} Message: Hi Below parts will be shipped out {{Delivery Date}} linking…
-
Can you collate Ancestors based on another column condition?
Hi all, looking for some formula help. I would like to collate the names of my ancestors for a task in my "Stage" column, but only if the Hierarchy level of that parent or grandparent is >= 3. I have tried utilizing the Join(Ancestors(Task@row), " - ") and this returns all of the parent tasks. When I try to utilize an if…
-
Using COUNTIFS with CONTAINS and OR
Hi everyone, I have been trying to create a pie chart in a Dashboard by referencing another sheet which has cells with multiple values from a dropdown, so that I can count the number of cells that CONTAIN some of the values. I've been trying to use the OR, so that it counts the boxes that contain any of the values, but I…
-
Can I use Join(Collect with multiple entry drop down?
Hi, I have a formula below that looks at 2 sheets and when the "PLY-Code Needed" from the 1st sheet finds a match on sheet 2, it gives me the "Description" from sheet 2. It works fine but as shown in row 131, there are 2 "PLY-Codes" and this makes this unable to pul the info. Any advice? Here is my Current formula:…
-
Formula help
I am counting assigned cases by month with this formula and getting an #incorrect argument error. Any suggestions on this formula. As you can see I have a helper column on the source sheet to reference the month: =COUNTIF({2025 Corr Officer Tracker_ BI Investigator Assign}, "Brian Blocher", {2025 Corr Officer Tracker_ BI…
-
Column Formula
Is there a way to break up a column formula after a certain number of rows? We have an inventory column that is broken into 2 sections which are divided by a row. For example: I'd like the first 100 rows to be one formula and the next 100 to be a different formula. I want to use a column formula instead of manual entering…
-
Index Match with a multi-select dropdown
I am trying to write a formula that looks at a multi-select column to pull email addresses from a reference sheet. With my current formula it only works when there is one value in the multi-select column. =JOIN(COLLECT({Reference Sheet | Contact Q2}, {Reference Sheet | BID}, HAS(@cell , [Sites to be included]@row )), "/")…