Use Custom Fields for Structure Formulas

Christopher Moretti June 22, 2021

I have a set of custom fields for implementation and verification details.  I have a structure with some custom columns using Formulas.  There seems to be some limitations or syntax issues I am running into with trying to find specific things within these fields.  I can't use ~ like I would in a JQL query.  I have not been able to use the functions MATCH or SEARCH because it is looking at the custom field as a set of text instead of a reference.  Is there a way to do this so I can do IF statements that check if a specific word, like "REWORK" is present in those fields?

2 answers

1 accepted

2 votes
Answer accepted
Christopher Moretti June 23, 2021

Found the answer:

"Names of the custom fields, with all non-letters removed and all spaces converted to underscores, for example, Story_Points."

Reference:

https://wiki.almworks.com/display/structure043/Formula+Column 

0 votes
Dave Rosenlund
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 7, 2021

@Christopher Moretti: In case you haven't already heard, you may be interested in the Structure 7 / Formulas / Expr 2 Bootcamp.

Best,

-dave 

Suggest an answer

Log in or Sign up to answer