Hi, everyone!
Is it possible for Ironclad to determine the maximum or minimum of multiple (not a simple compare of two) date values in a table? Excel, for example, can do this with "max(range)" or "max(multiple cells)", etc...
Our use case - we're running the Coupa<>Ironclad integration to import Requisition data into the workflow, and there can be multiple Item lines with variable dates (think of ramp subscriptions, or subscriptions and separate startup professional service, or multiple different product delivery dates, etc.), which we import into the workflow/contract as a table, and we'd like to parse that table to find the first of the start dates and the last of the end dates to calculate the contract start and end dates.
For example:
| Item |
Item Start Date |
Item End Date |
| Integration Support |
1/1/2026 |
3/31/2026 |
| Subscription |
1/1/2026 |
12/31/2026 |
| Mid-cycle review support |
7/1/2026 |
7/11/2026 |
So, in this case, the "Contract Start Date" would the earliest of the three Item Start Dates (1/1/2026), and the "Contract End Date" would be the latest of the three Item End Dates (12/31/2026).
I didn't see any formulas that looked like they could handle true maximum or minimum determination, but I may have missed something - any ideas?
Thanks!
