How do I update the Status from a date field column of another sheet

One sheet (sheet 1) a specific row contains a column/date field and I want to update a specific rows status field on another sheet (sheet 2) to status of Complete if a date is present in the source date field from Sheet 1.


  • Mike TV
    Mike TV ✭✭✭✭✭✭


    Is there a point of reference that exists on both sheets which you can use to help find which specific row the date is on that you want to look at? If so, you need to add a column to sheet 2 which INDEX MATCHES and references that data to bring in the date field into sheet 2. Then you can write a simple =IF(ISDATE( formula to change the other column on sheet 2 to "Complete" if a date is present.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!