Date Calculation Field - Use formulas to power up date fields!

Update on July 25, 2024

In the most recent update of Membrain, we are introducing date calculation fields. This new type of custom field functions similarly to the existing calculation field, with the main difference being that the output is a date instead of a number.

While the traditional calculation field can output numbers, including options for decimals and percentages, it cannot produce a date. The new date calculation field provides all the functionalities of date fields in Membrain, allowing for the creation of graphs, list views grouped by date, date-based rules, automation possibilities, and more.

This feature is useful in scenarios such as managing delivery times or tracking delays between contract terms.

💡 This enhancement offers flexibility in scenarios such as:

  • If you have a standard 30-day delivery time post-closing a deal, you can use the closing date plus 30 days to always have an accurate delivery date field.
  • For varying delivery options, you can link a date field, like the project start date, to a scorecard with numerical options representing different delivery speeds. The number output from the scorecard can then be added to the project start date.
These adjustments mitigate potential issues that may arise from inaccurate exchange rates so you can safely rely on these metrics for data-driven decision-making.
 
Need help with this update? Visit our Help Center, contact us via the in-product Chat, or reach out to us at support@membrain.com. We'd be happy to assisst!
 

More updates to Membrain