Oct 21 2022 02:43 AM
I would like a column that can automatically fill in a completion date when another column's value reaches 100.
I have percentage tracking that when a column is completed or 100% I would like the date in another column to reflect the day its value was changed. Is this possible using column forumla or would I need to consult the Power Automate experts?
Oct 21 2022 07:07 AM
@jamescosten you just need a calculated column set to return a date and a formula like
=IF(CheckClear/CheckItems<1,"",TODAY())
(in my case both CheckClear and CheckItems are also calculated columns)
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Oct 21 2022 08:38 AM
Oct 21 2022 09:11 AM
@jamescosten the dates don't update dynamically, only when you edit an item. But you can have a separate column with JSOn formatting that will display the date automatically, though not update it.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Oct 22 2022 05:15 AM