-
Workflow - lock/unlock rows
Hello, First of all thanks for helping :) I have this list of tasks where i use my WFIndex + Index columns to identify them and execute automations. My Milestones are "locked", colored in blue and in this case identified by WFIndex = 4 (row 8) I have a few "checks" which i want the user to mark as "completed" before…
-
How To Identify Max Value
Hello, Need help, I want to identify which questions have the highest "No" respond. On column "MAX - NO" will appear the name of the questions that have the highest No respond. Currently, I can identify the maximum of respond on each questions. I don't know which suitable formula to combined with MAX to capture which…
-
Raise Flag: If and statement
Trying to put in a formula that raising the flag if the end date is past the deadline and status is not marked as complete. This is the formula I have =IF(AND([End Date]5 > Deadline5, NOT(Status5 = "Complete"), 1, 0)) but it is returning #UNPARSEABLE
-
JIRA smartsheet connector with Formulas
Hello, I'm currently attempting streamline work status changes with Smartsheets as they are integrated with my JIRA instance via cloud connector. The way we currently run our projects within JIRA (that are synced to Smartsheets) is by creating "Epics" that have "Stories" mapped to them(as children). Through using the…
-
IF Formula (Due Date > Today's Date AND Request On Hold (Box Checked) = No Flag In Past Due Column)
Hello, I am trying to troubleshoot a formula to achieve the following outcomes. Outcomes: If the Due Date column is past today's date, trigger a flag in the "Past Due" column. HOWEVER: If the "Due Date" column is past today's date AND the "Request On Hold" column has a check box, NO flag in the "Past Due" column. Database…
-
Help with adjusting a formula
So the formula below is used to determine the colors of the dots. However, I need it modified so that for Blue Dots, they will be Blue based on the current condition already there, or if the start date or finish date are empty. I was unable to figure this out on my own so thought I would post it here =IF(OR(Status@row =…
-
Counting (and Averaging)within Columns
How do I create a Counting formula to count how many times an Owner Email created a Title on Create Date? Is it possible for me to add the average Score to that count? Example: 3 = anisiac (owner email) created Workforce Management Opp (title) on 1/13/2020 (create date) 91 = Avg Score
-
Smartsheet Function - TODAY()
I use this function, TODAY(), to calculate days to an event or past said event. I've noticed that you have to open the sheet to update or probably more accurately get the TODAY function to be active and calculate. I use this day counts in a Dashboard and to be accurate, as mentioned, I need to open that particular…
-
Need help creating a formula
I do a project status report for my team. We currently have status options like: "Not Started" , "Active", "Active + Concerns" and "Complete. I recently made another status option: "Cancelled - Covid19". I make a dashboard for my supervisor that highlight the number of projects that aren't complete due in the next 7 days.…
-
RYGB BAlls with B = empty cell
I have a basic formula I can't get to return a B ball when there is an empty cell. =IF(Count@row = 0, "Green", IF(Count@row > 0, "Red", IF(Count@row = "", "Blue")))