Using the "Created Date" field in formulas

KGetchell
KGetchell ✭✭✭

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!

Kate

Capture.JPG


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!