Forum Discussion

Qrew Cadet

10 months ago

Color coding formula based on another formula field

I have a formula rich text field called Last Opened Date with the following formula to trim a logged field so it only pulls out the date: Trim(Right([*Vista Last Opened Date (Log)],10)) In my rep...

RachelMiller

Qrew Cadet

Thank you Chayce. Do you know if I can change my Report Name field from text to a formula rich-text field without losing the data?

------------------------------
Rachel Miller
------------------------------

ChayceDuncan

Qrew Captain

10 months ago

If [Report Name] is a text entry field, and not already formulaic then no, you do not want to change it given that all of the data will be lost.

If it is an entry field - then you would want a 'new' field that is formula rich text, and you will just display the value of [Report Name] instead and you would swap out to using the rich-text field on reports potentially so it showed with the style you're looking for.

------------------------------
Chayce Duncan
------------------------------

RachelMiller
Qrew Cadet
10 months ago

Thank you so much Chayce!

Confidentiality Notice:
This e-mail, including any attachments is the property of Trinity Health and is intended for the sole use of the intended recipient(s). It may contain information that is privileged and confidential. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please delete this message, and reply to the sender regarding the error in a separate email.