-
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”.…
-
Checkbox, Texts, RYG
I am trying to create a formula based on checkbox and dropdown list column. The result I am looking for is for Column 3 to have either a Red or Green symbol based on if Column 1 is checked OR Column 2 includes a specific word. Column 2 is a drop down with multiple options. Is this possible?
-
How do I add text to a formula
My current formula below works, and returns the value, 25%. But I want to add specific text to the value returned. So it should read, 25% - Milestone 1, or Milestone 1 - 25% =INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) Thanks.