Project Completed If Date Entered

ChrisFix
ChrisFix
edited 12/09/19 in Smartsheet Basics

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)

Tags:

Comments

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭

    If you are just evaluating whether a cell is blank or not, this might work for you:

    =IF(OR(ISBLANK([Input Complete Date]@row), ISBLANK([Planned End Date]@row)), 0, 1)

    It'll return a 0 if either of the columns has a blank cell, if both are not empty, it'll return a 1. 

  • 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