-
IF AND formulas
I can't get the following formula to work, getting the #UNPARSEABLE error: =IF([Regulatory Impact Score]@row >= 3.75, "High"), =IF(AND([Regulatory Impact Score]@row < 3.75, [Regulatory Impact Score]@row > 2), "Moderate"), =IF([Regulatory Impact Score]@row < 2, "Low") If I separate these into three different formulas, they…
-
Sheet Summary COUNTIFS using netdays
I am trying to count how many requests are open for more then 2 days in sheet summary. The above formula results in #UNPARSEABLE
-
Embedded IF(AND(OR Function Help
Hello, I have three columns in my sheet each with dropdowns including a "Complete" - type answer and a "Not Required". In the fourth column, I am trying to write a formula to show when the row is 'good to go' - such that all three columns read either "Complete" or "Not required". I've tried to do this by embedding an "OR"…
-
Need help in AverageIf formula with 2 condition
Hi team, I need help with an AverageIF formula. I am working on the request tracking system for Import shipment. I would like to calculate the average days in transit with 2 conditions, 1. Country (USA, UK, Sweden, etc), 2. Mode of transit (Air mode, Ocean Mode, Courier mode) + Average days in transit. Existing AverageIF…
-
SumIF HAS with cell linking
Hi All, I have been struggling to find a solution on how to get a Sumif formula to work. Essentially, I want to Sum if a cell contains a specific name, however the name column is multiselect and can have multiple people in it. I have tried both the HAS and CONTAINS formulas but haven't been able to get one to work. The…
-
Calculating percentage based on status options across multiple columns
I am trying to average the sum across multiple columns. Each column is a single select dropdown that will allow the user to choose from the following options: ⦸ (Not applicable) ◷ (in progress) ✓ (Complete) I want to assign values to these symbols. ⦸ = 1 ◷ = 0.5 ✓ = 1 I have only been able to get the following formula to…
-
COUNTIFS Function - 0-30, 31-60, 61-90, >90 Days
Hi, I am looking to pull the total number of unassigned projects with 0-30, 31-60, 61-90, >90 Days. The "Completed" column is the date the form is submitted. I am getting a value of 0 when using the formula below. Thoughts? =COUNTIFS(Status:Status, "Unassigned", Completed:Completed, AND(@cell >= TODAY(), @cell <=…
-
Vlookup to find result in child row
Hi all I am after help on a formula to pull in information from another smartsheet using vlookup but at the child level. I am looking for a match in my project to Ref, which is 699 and then find the data within the child row from Task 01. In this case, the result would be DC The reason for this is that we need to create a…
-
Integrating Gaant View Items and Calendar View
I'm having an issue finding a solution for meshing Gaant charts on individual sheets and multi-sheet calendars. On individual sheets we have "Phase" dates, these are anywhere from a few days to a few months. These are great for the Gaant view. The group calendar shows all the items from the individual sheets, including…
-
Cells not multiplying correctly.
Hi, I have two adjoining cells that are not multiplying correctly. I have tried =[part qty] * [module type] and the formula returns "10" when it should return "20" I have tried =[part qty]@row 8 [module type]@row and the formula return "10" when it should return "20" Any help would be greatly appreciated. [Module Type} is…