Hello! I have a range of numbers I need to include in a logic function, specifically: < 3 = XS 4-8 = S 9-16= M 17-39= L >40= XL This is my logic string, and I've used a similar one in a previous sheet…
Any Suggestions on the simplest way to formulate this? * Dropdown Column - "Part Status" * Dropdown Options - "Delayed" "Not Started" "In Progress" "Warehouse" "Shipped" I want to show a total sheet s…
Hi, I need to create a notification when we have an order shipped to a State we have not shipped that product to in the past. The client's State is automatically added to the sheet from a workflow, an…
Hi, I would like to be able to return the Row ID of a given column - to use in the following formula: =ROWID(ANCESTORS([Task Name]1)) Which should return the row ID of the first ancestor (Parent) or t…
I would like to simplify a formula (if possible). Several items in the formula below have the same value (e.g. 25 or 10). =IF([Activity_1]1 = “JTA”, “25”, IF([Activity_1]1 = “IDW”, “25”, IF([Activity_…
Let's say my task sheet has dates that tasks are created - not necessary TODAY. And I want to run a report if the created date is this month. For example, Task A's created date is 09/10/2017, and this…
Columns "Risk" "Start Date" "Part Status" I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress" I have the formula below for if start date is today o…
Good Day All: I am trying to add to my existing formula if the date is not populated the harvey ball will remain yellow. If all conditions are met (date submitted, date approved, approved by committee…
Greetings, First time posting because I'm not well versed with formulas and I'm hoping that someone smarter than me can offer some guidance. I would like to create a form that assigns a point value to…
