I'm new to SharePoint and I'm not sure if the tool can help me with this issue:
I have a list with several items to organize activities/projects, as illustrated in the figure. The "Status" column is a "Choice" type, where there are some options to describe the status of each activity.
I would like that, when the person selected the option "Iniciado" ("Started", in English), the date was automatically added in the column "Data de início" ("Start date") and the same when selecting the option "Concluído" ("Done"), the date was added in the column "Data de conclusão" ("End Date").
The formula I'm using is:
In the "Start date" column:
In the "End Date" column:
You may have already realized what the problem is with this:
Looking at the third item, we see that it is "Done", but we don't have start date, because the status isn't "Started", although for it to be completed, it was started sometime.
In the fourth item, it should contain a date of beginning, since, if it is being finalized ("Finalizando", in portuguese), it is because it was also initiated someday.
I don't know if the problem was well reported, but the fact is that I want to have the start and end date of activities based on the day the status changes to "started" and "done".
Somehow I need to "lock" editing the "cell" when the date is added. I know that the formula I wrote really doesn't meet my need the way it currently is.
Is it possible to do what I want?
If you can help me, I would be very grateful!
*I'll add that the fact that I'm using the formula 'today' inside the 'if' function isn't bothering me. The date doesn't change daily like I thought it would. So if I change the status to "started" today, it will return today's date (November 8th) and tomorrow it will still be November 8th. The problem is if I change the 'status'.