Formula issues
Hello,
I am experiencing the following issue:
In a sheet I maintain my project data is, a single identifier for a completed activity is an entered date.
If date is lacking in the respective column, other value options are either a blank cell, or a status "Overdue".
What I am trying to achieve is count how many times in this column range, I have a date entry, which would tell me times the activity is completed.
I tried with various different formulas, like COUNTIF/s & SUMIF/s, >01/01/01 or by exclusion of blanks & "overdue" entries, but despite those formulas would work in a regular excel sheet, they don't work successfully in smartsheet.
Do you by any chance have a suggesion how this problem can be solved.
Thank you in advance!
Venelina Rusinova
Comments
-
Hi Venelina,
As you've found, function syntax differs from excel to Smartsheet.
I'd recommend checking out our article on creating functions in Smartsheet here to learn the foundation: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet
An example of a COUNTIF function that can count date values is below:
=COUNTIF([Due Date]:[Due Date], ISDATE(@cell))
This will count cells in the range of a column titled Due Date that contain date values.
More info on COUNTIF is available here: https://help.smartsheet.com/function/countif
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!