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?

Tags:
· Share on FacebookShare on Twitter

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. 

     

    · Share on FacebookShare 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!