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...
Thank you for the reply.
Will this change the date tomorrow? Or will it remain the date the column was completed?
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.
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.