I am using the field, "Total Days Open" to count the days between the date something is submitted and the date that work is completed. The formula is: IF(AND({Work Completed} = BLANK(), {Submission Date} = BLANK()), "",IF({Work Completed} = BLANK(), ...

I am trying to create a formal that adds a specific amount of days to a date field. The amount of days varies and is pulled using a lookup field. Initially, I was trying to use the DATEADD function but it doesn't seem to work when the added value is ...