-
CountIF Symbol & Between 2 Dates
Can someone help me with a formula that would count all the "Flags" in the "Work Related Exposure" if the "Created" date is between two dates ("Encounter Date" and "Date Resulted")?
-
Multiple IF or Match
Have a scenario that I want say if column A matches Column B, then enter value column C, If Column A matches, Column D, then enter value column E, If Column A matches Column F, Then enter value column G. Is this better done through some sort of MATCH or IF. I think IF, but can't get it work work (learning as I go).…
-
How to auto-populate hidden values for forms?
Hello, my name is Matthew, and I am working on a project that gathers data from clients. The goal is to receive documents from them and have them uploaded to SmartSheet. I would like to be able to send them a form based off a contact cell, but I am having trouble with this. The other issue is, unless they type what we have…
-
Multiple IFs Statement: Number to Name
We currently use numerical codes to denote our teams that are synced from JIRA. Those numbers are reflected in a column which I'd like to translate into the relevant team names. Team Column: 107 = IT-HelpDesk 108 = IT-EnterpriseApplications 109 = IT-CorporateInfrastructure 110 = IT-ProjectManagement I'd like to create a…
-
Multiple "OR" for single formula?
I have about 14 single choice options in a column that if chosen, lead to a specific Harvey ball status. I've used multiple "Or" entries, and I wonder what I'm leaving out, as it's coming back unparceable. Here's the formula: =IF(OR([EVAL Stage]2 = "Not Started", [EVAL Stage]2 = "Containment", [EVAL Stage]2 = "Starting…
-
Symbols Question
Hello, I'm receiving an "Unparseable" error on the below. I have a column where I selected symbols to display different statuses. I selected the colored circles where it is Green, Yellow, Red and Grey. Is this issue because I didn't apply the Yellow? =IF(Status@row = “Blocked”, "Red", IF(Status@row = “Closed”, “Grey”,…
-
Formula "Project is not complete and due day is passed"
Hi everybody, could you help me with a formula please: The Idea is if the Status of the project is not "Complete" and due day is passed (it's more then TODAY), i need the red symbol in the column. In other cases, i need nothing. Here is my formula looks like: =IF(Status22 = "In Progress", "", IF(Status22 = "Not Started",…
-
Counting Parents for a Specific Year
Our organization receives requests for work and some of these requests may have multiple actions that need to be completed. I have the additional action(s) indented under the first action (request) to try and display that this one request had multiple actions. Is there a way that I can count the level one action (request)…
-
Get a distinct set of values from an existing column without changing order.
Hello, I am trying to get list of values that has each value only once. Below I have my JOB NUMBER column and I am trying to create an automatically updating column that we will call DISTINCT NUMBER that lists each number once. The catch is that the JOB NUMBER column is always changing and I want the DISTINCT NUMBER column…
-
Add
I have 3 Sheets: #1 = Closeouts, #2 = Annual Incentives; #3 - Incentive Distribution When a closeout is completed, data is entered on Sheet#3 - Inc. Dist. I have a Data Mesh to pull the data from the # 3 to populate Info on #2 Ann Inc. I am trying to get a formula or function that will do the following: When an entry is…
