Good afternoon,
Recently we have started one of our sheets in Card View and on a handful of occasions, we have had users deleting cards (or rows) from the sheet, simply by clicking the delete button on the keyboard by accident. I have done a manual test on a copy of the sheet and doing so does not prompt the user to ensure that they do want to delete the card.
To handle this situation, I have created an automation that copies a row every time a comment is added, an attachment is added or when it's status changes. In order to identify which of the rows on the new sheet is the latest added I wanted to add a rank field, but am struggling because the main sheet has an autonumber field, this value can in theory appear more than once in the new sheet. I could rank based on the modified data and the autonumber value, but when the rank changes so does the modified date, so all instance of the same reference end up with the same ranking number.
The reason that I wanted to rank the rows was to move any previous rows that were copied from the main sheet with a value greater than 1 into a third sheet ready for them to be periodically deleted.
If it was a case where there was only ever one possible update to each row per day this would work by recording a date against each row as it was copied from the first sheet. However, some of the rows have many updates in a day and therefore I could end up with several lines all having the same ranking for the same autonumber reference.
Does anyone else have a solution that can handle something like this or is there a better way to do what I am trying to achieve ?
Thanks,
John
