Help with If ISBLANK or statement

faganc
faganc
edited 12/09/19 in Formulas and Functions

I'd like a column to populate "late" based on whether another column has a date in it or is blank.  Does anyone have any experience with nesting this type of formula?

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    =IF(OR(ISBLANK([column name]24), ISDate([Column24])), "Late", "")

    Try this... you need to replace your column name you're checking for the date in and set it up for the right row number. This for row 24. 

     

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!