Formating for dates past

edited 12/09/19 in Smartsheet Basics

I'm looking to set a rule for when my 'Finish' date column pass my 'Completion' date column. When I try to set the rule it only allows me set when passes a fixed date rather that a date set in a certain column? 

any help welcome. 




  • Chris McKay
    Chris McKay ✭✭✭✭✭✭

    Hi Gareth,

    What you're proposing is absolutely possible. Are you receiving an error?

    The formula you're looking for will be something like:

    =IF(Finish1 > Completion1, "True", "False")

    You'll need to make sure you're comparing the same column types, so both Finish and Completion will have to be Date formatted columns.

    Kind regards,

    Chris McKay