-
Countifs with special requirement
Hi, I need to use countifs to count the number of calls made to customers today. In my example, Touch 1 and Touch 2 are calls today, however I also need some filtering with user input. The criteria are as follow: Date equals to "Free Text Date" of 20/04/2020 (X1) Salesman equals to "Free Text Salesman" Peter (X2) Only…
-
COUNTIF Formula
I don't know why I'm getting zeros here. The reference sheet for Range 1 is a date column and Range 2 matches what is in the drop down menu. I also suspect that there's a more efficient formula to use - your feedback is welcome! Thank you, Kristina
-
SUMIFS with additional criteria
Hello, Please can someone help, I am using this formula to add one more criteria but it returns back saying #INVALID OPERATION, the formula works before i start using the AND to add the next criteria, and i cant see why? =SUMIFS({Cleaning Planner (CL) Range 4}, {Assigned}, ="Jamie Livesey", {Cleaning Planner (CL) Range 6},…
-
How do I SUMIF based on multiple parameters?
I am trying to calculate employee utilization rates in smartsheet. I want to know the sum of individual employee effort (in percentage form) at any given given date in time. I have a list of current projects that has a line item for each employee and their percent effort on the project. Each line also indicates the…
-
Pull in totals for Today & Yesterday via a link
We have (1) sheet that is used for basic data entry. No formulas or anything complicated. The user enters the date, start time, end time and categorizes the work they are doing by selecting a single category every task they complete. There are about 7 categories the user can choose from. In an effort to not disturb the…
-
Formula to determine how many times something occurred in a row
Hi everyone, For my business I have multiple trucks, and every morning we record the statuses of the trucks before they start driving. I have multiple columns, each one being the different trucks. In the rows for those trucks I record the statuses for the different trucks. So I have "Available","Breakdown" etc. I'm trying…
-
Sumifs with multiple criteria including one Multi-Select column
Hello - I am trying to sum a grant $ amount when one column is marked "Yes" to COVID-19 Related and the other column is either marked "Approve" or "Approve-Repurpose". I can't seem to figure it out. Can someone help? =SUMIFS([Grant $]6:[Grant $]350, [COVID-19 Related?]6:[COVID-19 Related?]350, "Yes" AND([Approve/Repurpose/…
-
Calculating a minimum payment figure using a formula or function
Hello, I'm hoping someone may be able to help me with something that probably seems quite obvious or basic however, my knowledge on formulas or functions within Smartsheet is not advanced, so I apologise in advance! I'm trying to get my finances in order and thought I'd use Smartsheet to plan this. I've done a screen shot…
-
Count average time to close action
Hey, Can anybody please suggest me with a formula that would calculate the average time a person takes to close an action assigned to him in a row? I have attached below the layout of the sheet. The formula should calculate the start of the time from when the date raised changes to a value and return a value in the time…
-
Help with vlookup/index/match
Hi, I'm trying to create a table that looks up data from a list of entries based on multiple criteria. I have been able to achieve PART of my task with different formulas but can't figure out how to achieve my desired end result. I tried Index/Match, vlookup/match but can't get it to work. I want the formula to be dynamic…
