I have a column named Final report type (Link to RPC) wherein if this is the company, then this should be the report type that should be seen. However, there are instances if the company is seen 2 or more times, the report type is not being disclosed (see screenshot). I would like to ask if this would be done via an automation script? or a simple editing of the field column?
Currently, if the company would do their endorsement, they would be choosing a report type. The picture here shows the report type and the corresponding company, but do note that the report types can be used for other companies as well. Then on another table, I would have a column that would link to the picture and just autopopulate it.