-
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…
-
I was wondering what I would need to do to make this formula return the accurate number?
At the moment, I have a formula that is not actually doing what I need it to do. Basically what I have is an inventory sheet and when folks remove from the inventory I need it to look at the cost of that item from the cost column in that specific row and return a total $ Amt Used. However, occasionally, the item is…
-
Need help with Formula
Hello I am not an expert in automation, So need your assistance in mapping one data. I have requirement wherein in one Smartsheet I have values in 3 columns and on the other Smartsheet I have all the values present 3 columns in Sheet 1 is present in a single column. I need put a function in such way that the formula first…
-
Avgerages, assigning a value to text, and parent/child formula
I'm attempting to insert a formula into parent rows that assign a % complete based on entries on child rows. The child rows responses are locked based on task completion. The options are: "Yes, In-Process, and Not Started." I've made these two stand-alone formulas that I "think" will work, but I can't get them to play…
