Forum Discussion
Auto add solved date on list with IF function, equal to other column's value
Hi Guys! I am struggling with the following, I have a "solved date" column, where I'd like to add the solved automatically, if status equals to Closed status then it should be the last modified ...
Eszter_003 you can't use Today() in a calculated column which is why you get the error. So you'll need to think of another way to achieve this. A simple flow in Power Automate could do update the list whenever the status column (in my case Status3) is changed. If this is of interest I'll post up the steps asap.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Hi RobElliott yes, I am definitely interested, could you post the steps?