-
Workaround for countif miscalucating unchecked boxes in column
Looking for any advice, guidance, on calculating unchecked boxes. I would like to use summary data and post to a dashboard for review and status of how many unchecked rows. However, it counts the added/unused rows at the bottom of the sheet showing an incorrect calcuating of unchecked marked boxes. We add rows to the sheet…
-
Count IF Question
Hello all, just me again with another Count IF question!!! I was curious if anyone could assist with a question of mine. I am using 2 Sheets. On Sheet A I have Audience Names that I am trying to match back to another sheet and see how many different campaigns are tied to the Audiences. I currently am using a count if…
-
COUNTIF & WEEK
Hi All, A client wants to be able to see how many calls were logged in thier current working week . However the working week begins on a Friday 00:00am and ends Thursday 11:59pm. I'm after a formula to count all entries with the word "Aberdeen" in the Column called "Club" in the mentioned working week . This counter would…
-
AND/OR Function for COUNTIF Referencing another sheet
Hello, Smartsheets Gurus! I am building a formula to reference another sheet {ISIR Pulls 2023-2024, Column EX Major (Range)} with two different EX Majors within the range I'm trying to total up. The two things I am looking to identify are EX Major "BSC" and "BSD". If I just do: =COUNTIF({ISIR Pulls 2023-2024 Range 1},…
-
am trying to count the number of inspections approved within a range of date formula not working
-
COUNTIF with a certain word in a week
Hi All, A client wants to be able to see how many calls were logged in thier current working week . However the working week begins on a Friday 00:00am and ends Thursday 11:59pm. I'm after a formula to count all entries with the word "Aberdeen" in the Column called "Club" in the mentioned working week . This counter would…
-
Use of COUNTIF and CONTAINS to search 2 columns for a specific condition
Hello all!!!; I am trying to search in rows across 2 columns for a specific condition that I want to count the total number of. These columns are in the same sheet (See attached). My formula that returns "UNPARSEBLE" is: =COUNTIF([AssignedText]:[AssignedText], CONTAINS("First.Last1", @cell, [NeedsText]:[NeedsText],…
-
Cell Link/Reference - COUNT Question
Good Afternoon all, hoping for some assistance with this formula I am putting together. For my Number of Dealers Column on Sheet 1, I am trying to get a formula to count the number of Dealer ID's that fall under a certain Market. For Sheet 1 the formula will be looking up cells from Sheet 2. The formula needs to match the…
-
COUNTIFS for prior period
Hi, I am looking to build a dashboard that displays prior month/quarter/year data. I have found ways to do this from a rolling perspective (Year (Today())-1) or specifying a year, such as (Year='2023')@Row, but none that appear to be scalable. I don't want to have to recreate any summary fields (with formulas)/reports/dash…
-
Trigger automation based on a count or multiples of a count
Hello. Im testing out triggering an automation based on a countif, but I cant figure out the logic to apply the automation as the countif increases. For instance. I want the automation to run each time we get 5 submittals via a form for the same category. Right now I'm using a metric sheet and a countif with a mod…