Forum Discussion
Column that adds the date when a column value equals 100
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...
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)
- Thank you for the reply.
Will this change the date tomorrow? Or will it remain the date the column was completed?- Calculated Columns will recalculate every time you update the item....
So if you update the item never again the date in the column will stay the same....
If you update the item the value will again be set to the today.
I personally would create a PowerAutomate Flow that runs on every update. The flow should then check if your data column equals 100 and if your completition date column is empty.
Only in that case should the flow set the completition date to now. 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)
