This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello community! Here’s what I’m seeking assistance with:
I have 3 fields total: Length of Service, Service Start Date, and Service End Date (or anticipated)
I would like to write a formula for the Length of Service field that does what I currently h...
After some tinkering, I figured it out! Pasted below if anyone was interested (I just over-thought the IF function :stuck_out_tongue: )
IF({Service End Date (or Anticipated)}<NOW(),
DATETIME_DIFF(
{Service Start Date},
{Service End Date (or Anticip...
