-
COUNTIFS with multiple criteria
I need help with creating a formula where there are several criteria based off two different things. My columns are "Received from LO" needs to be yes and "Document Type" is several criteria "Lease"; "Easement"; "Option"; and "Easement Option". I can't seem to figure it out. I have the first one done, but can't figure out…
-
Using Countifs in differents sheets and related with 2 columns
Hello everyone! I need some help. I'm trying to match a two formulas for each column, similar like these, |In Progress| =COUNTIFS({Progress}, <1, {Start}, >=DATE(2021, 05, 1), {Start}, <=DATE(2021, 05, 30)) ---- Result should be "2" since there're 2 dates in the column finish date with the month on May. (It should be…
-
How to use a value in AVG that is selected from criteria
Hello! Would like to ask a question regarding AVG and the ability to only pick up a value if a certain condition is meet. Here is what I'm using. =IF({Call Center_Help Desk Data Priority} = "Level 1 - Critical", AVG({Call Center_Help Desk Data Value TTFA})) Objective: To pull in a value to be averaged for all Level 1…
-
Projects rolling over from 2021-2022
Hello, I' currently working on our 2022 project sheet and it has identical columns from our 2021 sheet with changes to the projects that are listed, however, we have some from 2021 that are transitioning to 2022. Since they are still going to be working on the projects for the remainder of the year, I want to have project…
-
Can a field have a formula, and be editable??
I'm a relatively new user of Smartsheet, and am amazed at both its capabilities and the engaged community -- I've found answers to every question I've had. Until now... I have a solution I'm creating where there are multiple fields for components that make up a product. Because not all fields are necessary for every…
-
INDEX/COLLECT returns #UNPARSEABLE error
I am trying to pull PO totals over from one sheet to another where unique Claim ID numbers match that are present in both sheets. However, I keep getting the #UNPARSEABLE error msg. Formula: =INDEX(COLLECT({PO Value},{PO Value}@cell <> "", {Claim ID}@cell = [Claim ID]@row), 1) 1) {PO Value}: this is the source range that…
-
DISTINCT COUNT BY DATES
Hello, All. I'm new to Smartsheet and trying to find a formula that can pull unique/distinct names by date. For example, one employee can complete multiple reviews per date. I need to pull the total volume of reviews (Date of Review) by employee (Call Reviewed By). So, total reviews for each day for each employee.
-
Formula Needed
I am trying to see if there is a formula that will look at the Cells in row 1, and if matched to the any of the weeks in column Week Of, will return the corresponding deliverable value in Column1. Attached is the clip of my smartsheet. I tried the below formula given and it worked perfectly up until I looked at my sheet…
-
COUNTIFS not resulting in same count as filter
Hi all, Strange situation over here...I am looking to count the number of cells with the word "waste" in a column called Narrative. I started just by filtering the data to understand what volumes I would get. Then I decided to use a formula to pull this data onto another sheet: =COUNTIF({2021 Q3 Narrative}, FIND("waste",…
-
IF function
Hi, I have the below formula but it is not working. Can you see where I'm going wrong? =IF([(Fuel Expense) Fuel Type]@row="Unleaded Petrol (£0.25 per mile)","0.25",IF([(Fuel Expense) Fuel Type]@row="Diesel (£0.45 per mile)",0.45",IF([(Fuel Expense) Fuel Type]@row="Electricity (£0.10 per mile)","0.10"))) Column B needs to…