Sign in to join the conversation:
Hi all,
Is there a way to format numbers is thousands or millions to just K or M? Or any formula to do it?
Kind regards,
Grace
I dont see a format to do it but i think you could do it with a formula like the following
=IF(ABS([Column4]2) >= 1000000, (ABS([Column4]2) / 1000000), IF(ABS([Column4]2) >= 1000, ABS([Column4]2) / 1000, ABS([Column4]2))) + IF(ABS([Column4]2) >= 1000000, "M", IF(ABS([Column4]2) >= 1000, "K", ""))
Hi Ricki,
Thanks for sharing the formula. It did work!
Many thanks,
Follow-up question regarding this topic, please can you advise how can to display just 2 decimal places and what to add in the formula for amounts in billion?
Try taking the abs out of the formula?
Unfortunately it didn't work. The results says #UNPARSEABLE.
=IF([Summary Info 2]23) >= 1000000, ([Summary Info 2]23) / 1000000), IF([Summary Info 2]23) >= 1000, ([Summary Info 2]23) / 1000, ([Summary Info 2]23))) + IF([Summary Info 2]23) >= 1000000, "M", IF([Summary Info 2]23) >= 1000, "K", ""
I think thats just a parenthesis issue. try the following
=IF([Summary Info 2]23 >= 1000000, ([Summary Info 2]23 / 1000000), IF([Summary Info 2]23 >= 1000, [Summary Info 2]23 / 1000, [Summary Info 2]23)) + IF([Summary Info 2]23 >= 1000000, "M", IF([Summary Info 2]23 >= 1000, "K", ""))
I needed this too and Smartsheet was giving way to many figures past the decimal, so this formula should work (Column named "Price"):
="£" + (IF(ABS([Price]@row) >= 1000000, (ROUND([Price]@row / 1000000,0) + "M"),(IF(ABS([Price]@row) >= 1000, (ROUND([Price]@row / 1000,0) + "K")
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
I want to use a list of account numbers in one sheet for a dropdown in another sheet using Table View. When I select the sheet and column in the dropdown menu, it shows the correct column but is dropping zeros. I have provided a screenshot of the reference column and then what appears in the drop down. Any ideas?
