-
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…
-
Pull Items from another sheet set for earliest date
I'm fairly new to SmartSheets and have been trying to figure out how I can pull items from my master list to show what is set for the next launch. Here is an example of my master table I want the new sheet to capture a different row for every enhancement in the example it would grab. A,C and E. Any help would be greatly…
-
Smartsheet Link Cell Error
Hi, I'm trying to link two items from two different columns on one Smartsheet from another. I essentially have one project plan which only shows that project and another summarizing all different project plans and I'm trying to link the beginning and the end dates from the single-project plan into the summary sheet. The…
-
Auto Image Insert
Hello I've been trying to find a way to have an image in a cell which then shows up on an update request. I have a cell where the reviewer needs to choose an option but I want to give them a reference table. I've added a helper column in which I can manually insert a simple image to help the reviewer see the reference…
-
Dates in AVERAGEIF Formula
Hello all! I need to use formula averageif to count average of duration of projects in weeks, it is bases on the end date of it. I try to do it in Summary of the sheet. Here is the formula but id doesn't work. =AVERAGEIF([End Date:End Date], [End Date]@row<DATE(2019,12,31), Weeks:Weeks) It shows that this formula is an…
-
sum( not working
Hi All I have been using sum( on tables like this - had no problem until today when building a new table for October and sum will just not add up my columns - it has done so in previous tables ( have a double system going to make sure counts are correct) But i just cannot get it to work - have tried deleting the cells and…
-
Please Help!
I'm creating a CRM, I have 2 columns. One is the Sales stage with column properties (drop-down list) and the other is a probability% column with drop-down options. I want a formula that will add the percentage from the drop-down options based on the sales stage that's selected. Example if '1. Not Qualified' is chosen, I…
