Column formula issue when using for resource allocation
Firstly, I love column formula. They are fantastic.
I do have an issue though. Our business has a lot of active projects and a lot of tasks which in timeframe may take weeks or days, however, only require hours of work from individuals.
To manage this I have created an Allocation column and an hours colum to allocate the correct % of work for individuals within that time period.
The formula looks like this.
=IF([Start Date]@row = "", "", [email protected] / (NETWORKDAYS([Start Date]@row, [End Date]@row) * 6))
This works well to provide an overview of the level of work for individuals over a period of time.
However, the formula keeps on disappearing and being replaced with values.
This happens across different sheets and only happens when the column is being used as resource allocation.
Any assistance with this would be greatly appreciated.