Sign in to join the conversation:
Using an Countifs to look at a column called Account and count if not blank. The formula using is =COUNTIF({EMEAR Tiger Team Exec Engagements H2 Range 2}, "") . Expected count is 38 and returns 12.
The sheet being referenced is: https://app.smartsheet.com/sheets/59wgCjQqwPQ6jrFxH9RfVM6gpC2gQ93JP97GGhF1?view=grid
The metric sheet is https://app.smartsheet.com/sheets/cpJv57hrhGH99Xfvqhxj8M6rPGwm55Gw9Wq5RMW1?view=grid
Hi @Louis Martinez
I hope you're well and safe!
Thanks! I'll take a look and get back to you!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
@Louis Martinez
It seems like you've solved it already.
It should look something like this
=COUNTIF({EMEAR Tiger Team Exec Engagements H2 Range 2},<> "")
✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Hello! I'm currently creating formulas for a gift register to document the price ranges we have and how many are in each category. My categories are: £0 - £50 £50 - £100 £100 - £200 £200 + However, the formulas aren't pulling back all the data accurately because some of the cells include text too like 'less than £500' or…
I am struggling to create a formula for the RYG symbols. I would like to base it off percentage complete and due date. What I am looking for is: Red = Due date <2 days less than .90 and anything past due Yellow = Due date < 4 days less than .50 All other green
Hi there! Can anyone kindly please help me with this - I'm new to SmartSheets and having trouble working out formulas… In one column I have dates that Volunteers started volunteering with our company. The second column I used the following formula to get the number of years that it totals: =YEAR(TODAY()) - YEAR([Vol Start…
