-
Counting Cells with "This but not that" Critera
Can anyone help me craft an formula that allows me to count all cells that meet certain criteria but not others? Example: Count all calls where the "Valid Phone Number" is checked, but the "Confirmed to Start" is unchecked. Thanks in advance
-
How to count on another sheet how many terminated employees per month?
Hello, I am trying to use the following formula in another sheet to count how many employees were terminated on the system per month: =COUNTIFS({Status}, @cell = "terminated", Month@row, {Turnover per month 2021 Range 4}, Year@row, {Turnover per month 2021 Range 2}) What am I doing wrong?
-
How to count children rows with multiple criteria
I have tried this many ways and can't figure it out. The column names I am working with are: "CaseRegNum", "Type of Review", and "Status". Each parent row is a different year and beneath each year are cases IDs (these are in the caseregnum column). The cases are categorized into "general" and "special" (this is the type of…
-
Charting and Tracking duration of row item
Hi all, We track all of our roles our team is hiring agains in Smartsheets. As I'm creating a dashboard, I'm looking to see if there's an easy way to track and display (see image) how long each role sits within a bucket. For the sample image: The x axis would contain our recruiting "buckets" (i.e Review, HR, TA, Filled…
-
Is there a way to link Nintex Form to Smartsheet?
Trying to edit information on a sheet. I had created a Form but then found out that Forms cannot edit information on create new entries. Smartsheet SME is trying to help me with a formula that can help me edit information on my sheet. But the formula is not working. Can anyone give me step by step on how to add a formula…
-
Countif formula that counts that row if the date on one column matches the date on the other column?
This is my formula so far and I would like to add on to it - =COUNTIFS({Proj. Type_}, <>"OTU", {NTP}, AND(@cell >= DATE(2020, 10, 1), @cell <= DATE(2021, 9, 30))). How do I add on to this formula so that it counts it when it is 15 days and more?
-
How do I create an automation
Good Afternoon, I was wondering if I could create an automation when someone updates info on one sheet and a field on anther sheet gets updated automatically? what I want is if someone updates bill paid column on Invoice Status sheet, the Bill Paid column on another sheet gets updated by itself. How do I accomplish this?…
-
How to count rows where the dates are in the past?
I am currently using the COUNTIFS formula and need to add on to this.
-
Formula Help Countifs and Match
I'm trying to develop a cross sheet formula that will give me an error message if I've over-allocated equipment. This is What I've come up with so far but I get Incorrect argument. =IF(COUNTIFS(MATCH([Equipment Required]@row, {Equipment Total}, 1), >[Equipment Max#]@row, {EDBDate}, >=Start@row, {EDBDate}, <=[Last…
-
Import Value from Googlesheet into Smartsheet Cell
Hi Does anyone know if its possible to read a value from a googlesheet and then import it in a smartsheet - like the importrange function in google? Thanks