Need some help please - currently working on SharePoint 2013 online.
I have a choice column (drop down) called 'Stage'. In 'Stage', I have 3 choices;
I also have 3 calculated columns (formatted for Date only);
What I am trying to do is, if 'Start' is selected in 'Stage' drop down, it applies current days date in 'Start' calculated column. If you select 'Pause', then it applies current days date in 'Paused' calculated column etc.
I have got it to work using the following in each calculated column: (e.g. below is from the 'Start' calculated column);
What is happening though is, when I change from 'Start' to 'Pause' in 'Stage' it is deleting the previous entry. E.g. Start = 19/06/2020 but when changed to 'Pause', 'Pause' = 19/06/2020 but 'Start'=0. I want the previous entry to retain it's date (think of it like an audit trail).
Can anyone advise what I am doing wrong? Admittedly, I am only a week old in SharePoint so I am certain it's me that is the problem here. Would really appreciate any help, been on this for 3 days now and can't find anything online.