0

Is there a way to write date and hour on a column on every status change in sharepoint?

Example:

STATUS A -> write date+hour on column A

STATUS B -> write date+hour on column B

STATUS C -> write date+hour on column C

Like:

=IF(Status=READY;"DATE+HOUR";"")

I need to record date and hour on every status change. Regards

4
  • You can achieve this easily using Power Automate or SharePoint designer workflow. Commented Jun 22, 2020 at 10:03
  • Hi @GaneshSanap I'm not an expert, could you explain it better or give me an example of the flow?
    – MarkR
    Commented Jun 22, 2020 at 10:38
  • Check the reference link given for updating date columns in microsoft flow in my answer and general flow steps as given in Diksha's answer at: sharepoint.stackexchange.com/questions/281780/… Commented Jun 22, 2020 at 10:43
  • Those flow steps are given in sharepoint designer workflow. you can achieve the same using power automate/microsoft flow. Commented Jun 22, 2020 at 10:44

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.