Forum Discussion
Automatically increment numbers (n+1) in column F when date has changed in column E
Greetings, I am trying to create a spreadsheet where when anytime the date is getting updated, the OOS shows the previous value+1. For instance, next time I edit the date to 5/21/2023, the OOS n...
You can enter a new date in a cell in range E2:E20 in the attached file. This might be what you want to do.
OliverScheurich
Thank you for your reply. The rows are fixed. Let's say next time they see symptom A for unit 12, They will change the previous date to the new date without adding a new row. if they don't see symptom B for unit 45 on that date, column F should remain unchanged for that symptom.
Column B Column D Column E Column F (oos)
Unit 12 Symptom A 5/21/2023 6
unit 45 Symptom B 3/21/2022 3
Thanks
Puya
Thank you for your reply. The rows are fixed. Let's say next time they see symptom A for unit 12, They will change the previous date to the new date without adding a new row. if they don't see symptom B for unit 45 on that date, column F should remain unchanged for that symptom.
Column B Column D Column E Column F (oos)
Unit 12 Symptom A 5/21/2023 6
unit 45 Symptom B 3/21/2022 3
Thanks
Puya