use single select field values in input select

[Emma_Roeder]

Hi Everyone,

I’m trying to set up a field that calculates the length of service of our volunteers based on a single select box with options Active/Inactive. The formula is returning the correct info for active volunteers, but for the Inactive option the cell remains blank. How do I get it to return results for both options?

IF({Active/Inactive}=“Active”,DATETIME_DIFF(TODAY(),{Start Date},‘days’,IF({Active/Inactive}=“Inactive”,DATETIME_DIFF({End Date},{Start Date},‘days’))))

[Utility_Locator]

Formula connected to Single Select Field Ask the community

Looks like you may have a parentheses in the wrong spot, try this: IF({Active/Inactive}=“Active”, DATETIME_DIFF(TODAY(),{Start Date},‘days’), IF({Active/Inactive}=“Inactive”,DATETIME_DIFF({End Date},{Start Date},‘days’)))