-
Parent Flagged if Children Flagged
Hi all. I have a task list that consist of multiple parent rows with Children I have modifided so that if a task is delayed or dates are not added in the task will get a flag. What i would like is to have if one or more of the Cildren Rows are Flagged the parent row will be flagged. but cant figure it out. Ivé tried with…
-
Could someone help me with this formula?
We are asking our managers to use SmartSheet to enter information about their employees (via the add form). Be are requiring them to enter the employee ID which has to be 9 digits, but many times they don't enter all the numbers. I read about helper columns to check whether or not the format is accurate and then send an…
-
Formula not working
Hello, I am trying to make a formula that will automate a symbol based on a text in another column. Below is my current formula that isn't working. Any help would be appreciated! Designations I would like are: Complete = Green; Planned = Blue; In Progress = Yellow; ON HOLD or N/A = Red =IF(ISBLANK([RegSci Review…
-
How do you set a flag status if a date is in the past and status does not equal a certain criteria?
Hello! I’m having trouble getting a flag to turn on if my Production Wraps column date is in the past and the status is NOT “wrapped” or “wrapped/aired”. Here’s the formula I’m trying to use but am getting #incorrect. Any suggestions? =IF(AND([Production Wraps]@row > TODAY(), OR(Status@row <> "Wrapped", Status@row <>…
-
Flag formula
I'm struggling with the flag formula even after reading these discussions and downloading the formula tools. Goal is to: Flag if status is not “complete” and due date in the past Flag if status is blank and due date is less than or equal to 3 days from today Current formula that works is below. I've tried adding to it…
-
Identifying Duplicates
Hi I'm trying to work out a formula for identifying duplicates in a invoice column. what formula would i use and do i setup a separate column to populate the answer to the formula? my column name is 'Invoice No' thank you for your assistance.
-
Formula for counting number of past due dates in 1 column for a dashboard
I have 1 sheet with all my formulas on it that my dashboard pulls the data from and a sheet that has all my tracking details on it. The formula i'm getting from Chat GPT is =COUNTIFS({Past Due Activation Dates}, "< & TODAY()") but the answer i'm getting is 0. When it should be 4. I do have empty boxes within the column,…
-
Revise Formula - RYG
I am using this formula: =IF(OR(CONTAINS("Insert Word", [Column 2]@row), [Column 1]@row = 1), "Green", "Red") However, I need to revise it so that when column 3 (which is an additional column not mentioned in the original formula) contains a specific word, it changes my ball to yellow.
-
Copy unique email address then sum entries question
I'm relatively new to using Smartsheet, and I have a question regarding a formula I'm trying to create. My colleagues and I are tracking our steps for a work event, and I've set up a sheet and a form for them to submit their work email addresses, dates, and total steps. What I want to achieve is a formula that can…
-
Assistance with Join collect with multiple criteria and evaluation action
I need to collect the email if the position is either Position 1, Position 2 or Position 3, and the status is “FTE” And If the status is “Open”, then collect from a helper row I built with a different email. I got a single position to collect but am struggling with multiple choices and the evaluation if is “Open”.…
