Change Status Ball for Old Row Entry When New Entry of Same Name is Created


I have a sheet tracking facility access qualifications for contractors; I need to change the status ball for a previous entry when a new row is created of the same contractor. Basically, when "Ron Cook" has a new row entry, change the status ball on the previous "Ron Cook entry to trigger automation to move the old row to an archive sheet. Please assist. Thanks.

Best Answer

  • Paul H
    Paul H ✭✭✭✭✭✭
    Answer ✓

    Not sure what date you want to use, but something like this

    =IF([Start Date]@row = MAX(COLLECT([Start Date]:[Start Date], [1) Employee Name 1]:[1) Employee Name 1], [1) Employee Name 1]@row)), "Green", "Red")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!