I have a Projects Table
I Have a Time Table referencing the Projects Table
I have a Time Notes Table Referencing the time Table
In the Projects Table i have a virtual column called Related Time Notes with the formula
select(Time Notes[Time Notes],
[T_ID].[Project]=[_THISROW].[PO Ref])
currently, it looks like this in the view
Simon Bluck left the following note I am Groot on 01/19/2024 , Simon Bluck left the following note Im Batman on 01/19/2024, Simon Bluck left the following note I'm standing out on 01/19/2024
is there a way to get it to look like
Simon Bluck left the following note I am groot on 01/19/2024 ,
Simon Bluck left the following note Im Batman on 01/19/2024 ,
Simon Bluck left the following note Im standing out on 01/19/2024
I think you could avoid the manually created VC expression by using an expression based on system generated VCs.
You may have a system generated VC called something like [Related Times] in the Projects table.
You may have a system generated VC called something like related [Related Time Notes] in the Time Table.
If so then you could have an expression for the column [Related Time Notes] in the Projects table something like SPLIT(TEXT([Related Times][Related Time Notes]))
Now to have those list values with line breaks, you could modify the expression something like '
SUBSTITUTE(SPLIT(TEXT([Related Times][Related Time Notes])), ",", " ")
User | Count |
---|---|
17 | |
14 | |
8 | |
7 | |
4 |