-
Excluding Blank Cells in Formula
I have a master row that I would like to track the year's progress. In my image, I would like the [Status] ball to stay Green if "YES" and if blank in [Count] cells January - December. Want it to turn Red, if there is a "NO" in any [Count] cell. If all [Count] cells are blank January - December then "Blue" YES followed by…
-
COUNTIFS Formula For Total Number Of Assigned Projects To Individual
Hello, I am trying to troubleshoot a formula to achieve the following outcome. Outcome: Count the TOTAL number of rows in which [Assigned To (In-House Designer)] is "Danielle Morrison" AND the [Request On Hold] checkbox in UNCHECKED. Background Information: The Assigned To (In-House Designer) column type is a Contact List…
-
Forms with Workflow
Hi, Is it possible to creare forms with workflow e.g if I click "fruits" I will se options "Apples, Oranges..." If I click "Veg" I will se options "Tomato, Onion..." I would like to create Sales tool for my team so they can go step by step with sales process without missing steps. (Maybe you no other tools for doing that).…
-
Conditional Sections of a form
Hi, Is there any way i can create a form so that, if a certain field is selected from a dropdown menu another field then appears needing to be filled out? Any clarification needed feel free to let me know :) Cheers
-
Can I hide the weekend days for a task?
I have a task that spans a weekend. It does the correct calculation for the correct number of working days, but in the calendar it's a bit misleading for our team. It makes it appear as if the task is being worked on during the weekend. I would rather have it only displayed for the 'working days' per the calendar settings.…
-
Creating custom "enterprise managed metadata" column types for use in multiple sheets?
Hi there, Is there a way to create a new custom column type? For example, I'd like to create a column type "Department" which would be a drop-down that would be populated with a managed list of official department names. Ideally, this list of departments would be managed in one location, and then if any department names…
-
How To Identify Max Value
Hello, Need help, I want to identify which questions have the highest "No" respond. On column "MAX - NO" will appear the name of the questions that have the highest No respond. Currently, I can identify the maximum of respond on each questions. I don't know which suitable formula to combined with MAX to capture which…
-
Raise Flag: If and statement
Trying to put in a formula that raising the flag if the end date is past the deadline and status is not marked as complete. This is the formula I have =IF(AND([End Date]5 > Deadline5, NOT(Status5 = "Complete"), 1, 0)) but it is returning #UNPARSEABLE
-
IF Formula (Due Date > Today's Date AND Request On Hold (Box Checked) = No Flag In Past Due Column)
Hello, I am trying to troubleshoot a formula to achieve the following outcomes. Outcomes: If the Due Date column is past today's date, trigger a flag in the "Past Due" column. HOWEVER: If the "Due Date" column is past today's date AND the "Request On Hold" column has a check box, NO flag in the "Past Due" column. Database…
-
Need a report that summarizes clients assigned to staff
I have a very basic Smart Sheet: Staff Member (Contact List) Client name (Text Column) Age (Date) Birthday (Date) There are a few other columns, but they are not relevant to my question. I need to be able to run a report that summarizes the number of clients assigned to each Staff Member. I don't need to know anything…