How to truncate

Excel and Google Sheets allows me to Truncate. How do I do this easily in ROWS?

1 Like

Hey @rdglas :wave:t4: thanks for reaching out. Are you referring to —

  1. The TRUNC function? If so, I’m afraid we don’t have this yet :sweat_smile: but please feel free to add it to our feature request board here — https://feedback.rows.com/
    • If you’re trying to shorten the numbers, you could try our ROUND functions and alike to achieve that and for texts, the LEFT/RIGHT functions.
  2. Reducing decimal places? You can do that by navigating to the 123 on our toolbar and toggling the - and + buttons like so —
    truncate-numbers

Please let me know in case you’re looking for something else entirely and I could advise further accordingly :innocent:

Best,
Sourabh