How to center numbers in html table?

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(
"<table>
<tr>
<th><b>Status<b></th>
<th><b>Number<b></th>
<th><b>Value<b></th>
<tr>
<th><i>Live</i></th>
<th>",Text([Live Count]),"</th>
<th>",Text([Live Value]),"</th>
</tr>
<tr>
<th><i>Locked-In</i></th>
<th>",Text([Locked Count]),"</th>
<th>",Text([Locked Value]),"</th>
</tr>
<tr>
<th><i>Processing</i></th>
<th>",Text([Processing Count]),"</th>
<th>",Text([Processing Value]),"</th>
</tr>
<tr>
<th><i>Objection</i></th>
<th>",Text([Objection Count]),"</th>
<th>",Text([Objection Value]),"</th>
</tr>
<tr>
<th><i>ReSign</i></th>
<th>",Text([Resign count]),"</th>
<th>",Text([ReSign Value]),"</th>
</tr>
<tr>
<th><i>Action</i></th>
<th>",Text([Action Count]),"</th>
<th>",Text([Require Value]),"</th>
</tr>
</table>
")

0 5 94
  • UX
5 REPLIES 5

Hello!
Try something like this:

CONCATENATE(
"<table style='width:100%;'>
<tr>
<th><b>Status</b></th>
<th><b>Number</b></th>
<th><b>Value</b></th>
</tr>
<tr>
<td><i>Live</i></td>
<td style='text-align:center;'>", TEXT([Live Count]), "</td>
<td>", TEXT([Live Value]), "</td>
</tr>
<tr>
<td><i>Locked-In</i></td>
<td style='text-align:center;'>", TEXT([Locked Count]), "</td>
<td>", TEXT([Locked Value]), "</td>
</tr>
<tr>
<td><i>Processing</i></td>
<td style='text-align:center;'>", TEXT([Processing Count]), "</td>
<td>", TEXT([Processing Value]), "</td>
</tr>
<tr>
<td><i>Objection</i></td>
<td style='text-align:center;'>", TEXT([Objection Count]), "</td>
<td>", TEXT([Objection Value]), "</td>
</tr>
<tr>
<td><i>ReSign</i></td>
<td style='text-align:center;'>", TEXT([Resign Count]), "</td>
<td>", TEXT([ReSign Value]), "</td>
</tr>
<tr>
<td><i>Action</i></td>
<td style='text-align:center;'>", TEXT([Action Count]), "</td>
<td>", TEXT([Require Value]), "</td>
</tr>
</table>"
)

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/35... 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.

Markus_Malessa_0-1708611205642.png

 

Thanks for your reply, it would make sense, perhaps its in development

Top Labels in this Space