-
Formula question
I am struggling with the formula. I need to pull the info from all the cells that contain the "ITEM" and give me the total number. Some cells have multiple items, so when i use the COUNTIFS formula it does not pull the info from the cells with multiple items in it. What formula should I use? I need to take into account…
-
How to use @row inside the OR function
When using the OR function inside COUNTIF, can @row be used? The following is a basic example when calculating the number of times an agency names appear. · The formula references the Agency column in another sheet which has three possibilities. One option is “BOTH” which represents both agencies. Therefore, a count of one…
-
Re-submit for approval
I'm trying to work out a workflow that allows someone to re-submit for approval. I'm not sure how to record an update to a previous denial. Sequence Request submitted-> Approval Request to VP VP Declines-> Notification sent to requestor Requestor updates request (existing request in sheet) -> here's where I lose the…
-
COUNTIF with date range and another critieria
Hi, I'm trying to count the number of rows which have a 60-day opt-out window between x and y and where the "Monthly DataCor Revenue" is blank. This formula works (y'all helped me with this): =COUNTIFS({Lite 60 day opt out}, AND(@cell >= DATE(2022, 8, 1), @cell <= DATE(2022, 8, 31))) but I cannot get an answer when I add…
-
Harvey Ball formula based on dates
Hello, I have Revision Due column and I would like to automate the Harvey Ball formula that if the Revision Due date is older than today's date the ball would be Red. If the Revision Due date is within 60 days of today the ball would be yellow. If the Revision Due date is days the ball would be green. I've tried the…
-
Bypass Circular Reference
I've gotten myself into a bit of a pickle here and I see no way out, I have three columns: Primary, Level, and ParentID. The Level is the number of ancestors that a row has. The ParentID is an identifier of which Level 1 row this row is descended from. ParentID has a formula which is: IF(Level@row = 0, "", IF(Level@row =…
-
Group Report by Month and show current month first.
Hi there Community, I'm trying to pull a report that shows my due dates for all my projects. I want to group the due dates by month. I created a formula that pulls the month name from the due date. If I have a project that's due 6/15/22 and another one due 6/27/22, the formula will pull 06 JUNE for both of them. I then…
-
If status is open and risk is high then X
I'm trying to create a formula that references two columns (Status and Risk Rating) to display the "no", "hold" or "yes" symbols. If the Status row is open AND the Risk Rating is High/Medium/Low, etc... I have the formula to work if I am just referencing risk rating IF([Risk Rating]@row = "High", "No", IF([Risk Rating]@row…
-
Conditional Formatting Help
I am wondering if there is a way in Smartsheet to be able to setup conditional formatting so that in a column called "Current" there is a cell in row 1 that has the logic to show that the current month is June-2022. I have this setup already (and so on July 1st it will switch automatically to July-2022. What I want to do…
-
Formula help please
I just can't get this to work. The first part of the formula works, but I having difficulty getting it to return a different option First Part =IF(Urgency@row = "High", [Date Issued]@row + 3) =IF(Urgency@row="High"(), [Date Issued]@row + 3), IF(Urgency@row = "Medium"(),[Date Issued]@row +7), IF(Urgency@row = "Low"(),[Date…
