Solved: Calculate a sum or difference of two columns, only... - Page 2

Joe_Seiler · 12-15-2022 01:23 PM

How would I write an expression to perform this calculation only if both of these columns are not blank?

[On Site Date Time]-[En Route Date Time]

I was thinking maybe something like:

AND(ISNOTBLANK([On Site Date Time]), ISNOTBLANK([En Route Date Time])), [On Site Date Time]-[En Route Date Time]

Pretty sure I'm on the right track, but don't know exactly what do to

Joe_Seiler

Good call!

Here's the final

IFS(AND(ISNOTBLANK([On Site Date Time]), ISNOTBLANK([En Route Date Time])), [On Site Date Time]-[En Route Date Time])

Calculate a sum or difference of two columns, only if both columns are not blank