-
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.
-
Trying to combine 2 AND functions with an OR
Hi There! I am new to SmartSheets and am working on a way to automate a process using the OR with AND's and running into trouble. Basically, I am trying to check a box in a column if any of the following is true. If the Model type is 1 AND the version is less than 9 OR If the model is 2 AND the version is less that 18…
