Using the "Created Date" field in formulas
Hello - I am creating a number of fields in various sheets to calculate lead times. One KPI we want to track is the life cycle of a project. I have added the "Created Date" field to all sheets and have an additional field that populates an Invoiced Date. I want a new field that will calculate the number of days between the two. A simple =[Invoiced Date (EP)]@row - Created@row formula is returning as #INVALIDOPERATION.
Is it possible to use fields with date/time combos in formulas? If so, does anyone have any guidance on how the formula should be setup?
Thank you in advance!
Help Article Resources
Check out the Formula Handbook template!