-
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…
-
Hello,
I am currently working on a digital performance evaluation. I have created a smartsheet with employees names, supervisor email, 30 day review date, 60 day review date, and 90 day review date. I have created a smartsheet survey for the employee to complete and a survey(evaluation) for the supervisor to complete. I would…
-
If column does not contain string return N/A
Hi, I've created a formula to return me the average "word" that appears when the Title column contains the string "1. Establish Baseline for Web Performance": =IF(AND(COUNTIFS(Rating:Rating, "Extreme-4", Status:Status, "Open", Title:Title, "1. Establish Baseline for Web Performance") >= COUNTIFS(Rating:Rating, "High-3",…