How to get the ID of percentcompleteoverride.period instead of its text label in a Saved Project Search Formula? In a formulatext, percentcompleteoverride.period.id just returns the text label like percentcompleteoverride.period does, and a formulanumeric says the field is not found.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you are trying to get the ID of

percentcompleteoverride.period

instead of its text label in a Saved Project Search Formula. However, it appears that NetSuite does not provide a direct way to retrieve the ID of a period in a formula. In a formula text, appending

.id

to a field ID like

{custrecord_custom_list_field.id}

usually returns the ID instead of the text. But in your case,

percentcompleteoverride.period.id

is returning the text label, similar to

percentcompleteoverride.period

. Unfortunately, using a formula numeric says the field is not found because it's expecting a numeric value, not an ID. One possible workaround could be to create a custom field that stores the ID of the period and use this field in your search formula. However, this would require additional scripting and configuration. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******