Forum Discussion

PUYAG's avatar
PUYAG
Copper Contributor
Apr 26, 2022

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 needs to be automatically updated to "6". 

 

Here is the sample sample:

      Column E        Column F

       Date                 OOS

       4/21/2022         5

 

Thanks

Puya

 

excel

2 Replies

    • PUYAG's avatar
      PUYAG
      Copper Contributor
      Apr 26, 2022
      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

Resources