Formula inside custom column | Formula en columna personalizada

Rtches

It is possible to enter a formula in a custom column?, e.g. add 2 days to the start date and obtain a new date or subtract the actual cost from the expected cost.
¿Es posible introducir una fórmula en una columna personalizada?, por ejemplo sumar 2 días a la fecha de comienzo y obtener una nueva fecha o restar el coste real del coste esperado

vicky

¡Hola! You cannot insert custom formulas in custom columns, there is not such feature.
That means you cannot add or subtract a duration to a date.
To perform calculations you can export the view (showing the columns you need to calculate with) as Text, open the exported data in a spreadsheet app (like Excel, Numbers.) and enter your formulas there.
Read more on how to export the data here:
https://www.projectwizards.net/en/support/faq/third-party/csv-export-excel

BTW should you need the difference between Expected Costs and Planned Costs, you may use the column 'Expected Cost Variance'

Best regards, Vicky

Rtches

vicky BTW should you need the difference between Expected Costs and Planned Costs, you may use the column 'Expected Cost Variance'

No I need it, it was only an example. I have a lot of macros in Microsoft Project to calculate values of performance of activities acording to quantities on each activity and similar values.

Frank Blome

Can you please give me a few field calculations ind detail? Thanks!