KevinT - profile

KevinT · Jan 29, 2023

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(), ...

KevinT · Jan 23, 2023

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 ...

KevinT · Jan 29, 2023

Thank you! That fixed it.

KevinT · Jan 25, 2023

The timezone would be GMT-5 (EST)

KevinT · Jan 24, 2023

Thank you, Adam! The formula is working now, however, the date is still slightly off. It is returning a date that is one day ahead of the expected SLA. In the attached screenshot, the submission date is 9/19/22. With a 90-day SLA, it should return a ...

User Statistics

User Activity

Is it possible to use the Rollup field to average values that are a formula?

Date Calculation Formula

Re: Date Calculation Formula

Re: Date Calculation Formula

Re: Date Calculation Formula