Relationship fields: Status
I have a project parent table and report child table. In the report table, my team creates monthly reports that include an overall status field. I'd like to be able to display that overall status fiel...
Forum Discussion
The other solution now that we have combined text summary fields is to do a summary of the Maximum Record ID# of the child records and look that up down to the children.
Then do a Combined Text summary of the Status where the Record ID# = [Max Record ID#]
The result will be the "pill" appearance for the current status, but you can then make a formula field
ToText([my combined text summary status field]) to make it look nicer.
Then do a Combined Text summary of the Status where the Record ID# = [Max Record ID#]
The result will be the "pill" appearance for the current status, but you can then make a formula field
ToText([my combined text summary status field]) to make it look nicer.