Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Formula based on Single Select Field question

695 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Emma_Roeder
5 - Automation Enthusiast
5 - Automation Enthusiast

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’))))

1 Reply 1
Utility_Locator
6 - Interface Innovator
6 - Interface Innovator