Hey Guys, I have the following formula that filters items in a table marked as “review” and then outputs a bulleted list of the the items to review. The list output is a column that contains a link so the reviewer can click on it and go to the item to review.
However, this means they get a bulleted list of URLs with no context. Instead, I was looking to use Hyperlink() to name each of the links as another value in the table such as “task name”.
.[Link to File]
"no link provided")
Is there a way to insert Hyperlink(URL, DisplayValue) in the above formula and specify that the Display Value is the same row in DB Tasks but a different column to [Link to File], so that the output is a bulleted list of Display Value text instead of a raw link that exists in DBTasks.LinktoFile