after adding a row
I have a formula in the 5th column which is:
=XLOOKUP(1,([@Data]=PlanTable[Data])*([@Utilaj]=PlanTable[Utilaj]),PlanTable[Plan])/COUNTIFS([Data],[@Data],[Utilaj],[@Utilaj])
I’ve tried selecting the whole column and change the format, it didn’t work, it continuesly converts it to dd-mmm-yy.
New contributor
Dănilă Laurențiu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.