Mark an old submission



I have a sheet I created where a name and status are being inputted through a Smarthseet form. I am trying to figure out a formula to mark old submissions.

Meaning if someone submits a name with the status of "Onboarding" and then submits the form again with the status "Hired", what formula can I use to mark the old submission?

I'm not sure if the Modified/Created Date option will work because sometimes a submission can happen within the same day or even the same hour.

I was playing around with duplicate and a MIN formula based on Row ID, but couldn't figure it out.

Thanks for the help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!