Pick current date based on the dependent column

I have developed a Microsoft list form. As you can see in the screenshot, I have some cases in an unverified state. I want to create a validation formula so that when I assign a case to someone, the current date is automatically selected. It means "Assigned Date" is dependent on "Assigned to" Could you please help?Read more

How to make "Assigned Date" dependable to "Assigned to"

Answer

Yeah, you *could* try 'hacking' it with a calculated column(dont do it Nehad I got something else for you) , but l got to cut in — that’s static and doesn’t even handle `Today` dynamically. Cute, but useless.

And here is the proper way-->

- Trigger: “When item is created or modified”

- Condition: `AssignedTo` is not empty **and** `AssignedDate` is empty

- Action: Set `AssignedDate` to `utcNow()`

And boom!?. Auto-fills the moment you assign someone. No nonsense.

You're welcome.