-
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…
-
There are too many cells referenced by formulas in this sheet
Hi, I get this message "There are too many cells referenced by formulas in this sheet" every time I load a specific sheet. Then the sheet disappears & Chrome leaves this message: Aw, Snap, Error code: Out of Memory Would anyone have an idea how to tackle this ? I'll try to clean Chrome temporary files to get more available…
-
Pulling in selected data from another sheet when conditions are met & then marking that as used
I have a complicated use case I could use some help with. Apologies if I'm using the wrong words here; happy to provide clarification. Here's what I'd like to happen: User submits a form to request a voucher for a specific exam. Row in SmartSheet 1 is populated with user's data. Upon row population, another sheet…
-
% Complete and Symbols
Hello - does anyone know how to create a formula that when a certain symbol is selected, it will return a status? Screen shot below. -Empty; return status 'Not Started' -Quarter, Half, or Three Quarter; return status "In Progress" -Full, return status "complete" Thank you for your help!
