+4Hello,
Is it possible to consolidate several Text - Multiple Choice field types into 1 field for a report? I believe I would have to create a new field and a text-formula as well. My working theory is below:
[Scope 1 Manufacturer] and [Scope 2 Manufacturer] and [Scope 3 Manufacturer] and [Scope 4 Manufacturer] ="Company A"
We have over 100+ customers, so creating 100 field types for each customer seems to be ineffective option. Thanks! I appreciate this community's help.
Best answer by DonLarson
Joshua,
You said that you needed to pull data of the manufacturer and the scope. Your formula or the List function that
A Table of manufacturers gives you one source of truth. You do not have to have Dell in four separate list and maintain them. You also can keep adding info about the manufacturer and expanding what the Bids know through the relationship.
The formula you posted does not have any conditionals in it. Are you looking to evaluate who the manufacture is to show something? For example:
If ( [Related Scope One Name]="Dell", "A value for the report", "A different value for the report)
+24Sorry, I would like to help, but I don't think we are understanding your question. Can you explain in words the business use case for what you're trying to do with some examples. Then we can probably help.
+4As for an example. I included a screenshot of a formula. If this caused more confusion, please let me know.
Joshua,
You said that you needed to pull data of the manufacturer and the scope. Your formula or the List function that
A Table of manufacturers gives you one source of truth. You do not have to have Dell in four separate list and maintain them. You also can keep adding info about the manufacturer and expanding what the Bids know through the relationship.
The formula you posted does not have any conditionals in it. Are you looking to evaluate who the manufacture is to show something? For example:
If ( [Related Scope One Name]="Dell", "A value for the report", "A different value for the report)
Joshua,
If you just want to string together the names of the manufacturers, then Mark's solution would give you a column of names.
A list of the names can be done like this:
[Manufacturer 1] & " " & [Manufacturer 2]
This will give you a row with a space between the names.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
