Formula fields in Structure

Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 1, 2023

Hi Community,

In Structure, can you create a formula field that outputs the the diff between two date/time fields in minutes?

1 answer

1 accepted

1 vote
Answer accepted
Kelly Arrey
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 4, 2023

Hi @Mikael Sandberg I'm pretty sure that's possible. Here's the Structure Cloud Sample Formulas page.

Here's a sample formula for "days past due": 

IF dueDate < NOW():
   DAYS_BETWEEN(dueDate, NOW()) CONCAT " days late"

Here's a link to the Structure Formula Duration Functions page.

David Niro
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
June 5, 2023

@Mikael Sandberg ,

@Kelly Arrey is right, it is possible using a formula column.  The function you will want is HOURS_BETWEEN().  You can multiply by 60 to get the minutes.

something like:

HOURS_BETWEEN(datetime1,datetime2) * 60

Best,
David 

Like # people like this
Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 5, 2023

Awesome, thank you both!

Like David Niro likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events