SharePoint - using data being changed in one list column to populate another column with a default value

Question

I have a list in SharePoint, and one of the columns is called 'status' - it is multi choice with 2 choices (open or closed). There is another column called 'closed date', containing the date that the status was changed to closed. Is there any way for 'closed date' to be automatically populated with today's date when the status is changed to closed? So that the user only needs to change the status, and doesn't need to fill in the date themselves.

Thanks in advance.

Answer 1

Hi Katie,

Thanks for posting in the community, I’m glad to offer help.

According to your description, you can try to set the “Closed Date” column as “Calculated” type instead of “Date” type, so that it can return values via a formula based on other fields, here are the steps:

Click “+Add column” > More… > choose “Calculated (calculation based on other columns)” > type the formula =IF(Status="Open",Status,IF(Status="Closed",TODAY(),"")) > set the return value type to “Date” > save the changes.

 

Please note that the “Calculated” column is only used to return values, it cannot be used to input data or edit the returned value.

Hope the above method can help you, please feel free to let me know if it works or you have any concerns, I’ll continue to help you.

Best Regards,

Arck

Answer 2

Hi Katie,

I’m writing this reply to follow up this case, may I know if you have checked my last reply? When you have time, you are welcome to post back to let us know if it helps or you still need help here.

Hope you are all well during this period, please stay safe and take care.

Best Regards,

Arck

Answer 3

Thanks you very much for your help.