Forum Discussion
Solved
Return "Specific value" from table 1, if not found, return value from table 2
Hello, I have Table A and Table B, and I need to create a visual to show the Project Name when selecting a Project Number. Is it possible to create a calculated formula to return Proj Name if foun...
Hi, I found a solution by apending the two tables, concatenating both Proj Name columns and filtering out the blank and duplicates.
Thank you all for your replies.
Hi, I found a solution by apending the two tables, concatenating both Proj Name columns and filtering out the blank and duplicates.
Thank you all for your replies.