I am currently working on a financial control board. This is linked to various time tracking boards which after a lot of try and error now works quite good. The hours tracked for a person multiplied by an hourly rate gives money spend per cost center. I want to set up an automation that sets the hourly rate into a number column like “when person is assigned to someone set number to”. Another automation sets person as the tracking person, thus no manual input would be required to set up the cost calculation. However, I was suprised not to find the custom automation “when person is assigned as someone…” as it seems so basic. Did I miss something? Help is highly appreciated.
Once finalized I am most happy to share our time tracking and cost controlling system as many people seem to struggle with it.