Project Completed If Date Entered
Hi,
I am trying to extract a confirmation from a row containing dates. The objective of the following formula is to determine if a date has been entered and if so, display the number 1. If not, to Display a zero. Note, the formula works when information is not entered in to a DATE column, however when the cell is blank, it produced the first option of "1". My assumption is that there is something wrong with the Columns with regards to Formatting Text vs Date. As well as the last comment in the formula.
FORMULA:
...IF(AND([Input Complete Date]6 >= [Planned End Date]6, [Input Complete Date]6 > 0), 0, "1")
Columns:
Input Complete Date1
Planned End Date1
Complete (where the formula sits)
Comments
-
Hi Nic,
Thank you for deciphering the message. This worked in identifying cells with dates that are late and/ or missing information.
Many thanks,
~C.FIG
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives