Jul 28 2022 12:51 PM - edited Jul 28 2022 12:52 PM
Hi, I have two columns (updated and last completed) that I want to interact with each other. I want the “updated” choice column to reset to no if the “last completed” date column changes. And also want the new response in the “updated” choice column to change only if the date is changed again. Any ideas? Thanks in advance.
Daniel
Jul 28 2022 01:08 PM
@Danielstout From what I understand, you want to update 'Updated' choice column whenever 'last completed' column changes value. You can easily do this if you write an automation Flow to trigger when an items changes in your list.
Here is how I would do it - create another column and call it something like 'last updated hidden'. On every item update write the value of 'last updated' column to 'last updated hidden' column. So that you have something to compare if 'last updated' changed or not on every item update. If it changes, you can edit value in 'Updated' choice column.
Jul 28 2022 01:13 PM