Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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!
I am in conditional formatting and cant seem to figure out how it should be set up. This is what I am looking for. I'd like a cell to turn red if it has been 365 days since the date that is listed in the cell. Any help is greatly appreciated!
The below formula should give me the total price of a project filtering it by the panel name and the area. I do not want to include a certain supplier. Also Level 1 is totalling the child rows, so I want to filter that out as it give an inaccurate overall total of the price allocated to the panel and area. I can't figure…
I've created a dashboard with multiple graphs using data from the same report. I have added the report to the dashboard as well and set up the filter for use in the dashboard. Is this filter transferable to the graphs as well, given i can filter the report in the dashboard?
