My table text is as below, but I want to center the numbers in the middle column of each row, can anyone please assist
concatenate(
"
| Status |
Number |
Value |
| Live |
",Text([Live Count])," |
",Text([Live Value])," |
| Locked-In |
",Text([Locked Count])," |
",Text([Locked Value])," |
| Processing |
",Text([Processing Count])," |
",Text([Processing Value])," |
| Objection |
",Text([Objection Count])," |
",Text([Objection Value])," |
| ReSign |
",Text([Resign count])," |
",Text([ReSign Value])," |
| Action |
",Text([Action Count])," |
",Text([Require Value])," |
")
Hello!
Try something like this:
CONCATENATE(
"
| Status |
Number |
Value |
| Live |
", TEXT([Live Count]), " |
", TEXT([Live Value]), " |
| Locked-In |
", TEXT([Locked Count]), " |
", TEXT([Locked Value]), " |
| Processing |
", TEXT([Processing Count]), " |
", TEXT([Processing Value]), " |
| Objection |
", TEXT([Objection Count]), " |
", TEXT([Objection Value]), " |
| ReSign |
", TEXT([Resign Count]), " |
", TEXT([ReSign Value]), " |
| Action |
", TEXT([Action Count]), " |
", TEXT([Require Value]), " |
"
)
2 Likes
I appreciate the assistance, it is similar to what I have been trying, but still the column is left aligned
According to the documentation here https://www.googlecloudcommunity.com/gc/Announcements/Rich-Text-Formatting-in-Preview-Program/m-p/352427 inline styles for html tags are removed for LongText fields with HTML markup. That would suggest that alignment in table cells are not possible at the moment. I am wondering with several others having talked about SVG capability if this is something to explore.
2 Likes
Thanks for your reply, it would make sense, perhaps its in development
