
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 22, 2019 09:54 AM
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

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 22, 2019 01:14 PM
