Weekly Count

valenzuelat

valenzuelat ✭✭

05/24/23 in Formulas and Functions

I need to count values weekly that don't have dates. I need to see progression weekly of how many still remain/left. We have data that's when it's completed it'll remove from the sheet. Needs assistant!

Tags:

Support

0 ·

Answers

Hollie Green ✭✭✭✭✭✭

05/24/23

=Countif([Date Column Name]:[Date Column Name],"") That should count any blank cells in the date column you are looking for

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Creating a multi-sheet formula to match a contact list that references a drop-down list
Hello to you, Smartsheet community! I am in need of assistance with formulas. I'm so lost in the syntax that I don't know right from wrong, up from down, HAS or COLLECT 😵. I do not identify as a power user with formulas — wizards are my dearest friend — so this push into the advanced features has been a journey. Is it…
Conditional Formatting for Dates
I have two columns, one with a projected date and one with an actual date. I want the actual date to turn red whenever it is later than the projected date. How would I make this happen?
IF formula from Excel to Smartsheet
Hi, I currently have a spreadsheet in Excel I am moving to Smartsheet with an IF formula. Can someone help translate what this formula should be in Smartsheet? In Excel, the Current Widget Liabilities formula is: =IF((2023 Paid Widget Balance + 2024 Paid Widgets - Widgets Created in 2024) <0,0,(2023 Paid Widget Balance +…