Apr 04 2022 07:59 AM
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 date (it's another columns value), for anything other status should be today's date. I modeled the logic in excel, it works there, but when I translate to Sharepoint it says error, I just can't figure out why it is not working. Does anyone has any idea?
I have come to this formula: =IF([Status]="10. Closed";[Modified];IF([Status]="12. Closed";[Modified];TODAY()))
Thanks!!!
Apr 04 2022 08:37 AM
@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
Apr 04 2022 09:18 AM