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")
as you can see in the picture bellow, I want to make a function to generate an auto sum for each day where any time day changes, I get the sum directly of the same day. P.S: numbers in DailySum are random and for AmountIQD it has this function =[مجموع الاليات]@row + [مجموع العمالة]@row + [مجموع المواد]@row your help is…
Hello I could use some help with this formula. Here is the formula I am using the bright yellow column to hold the formula. so you can see the results of that formula below =IF(ISBLANK([Initial Approval Date]@row ), " ", [Homeowner Approval Initial Status intake]@row + [Homeowner Approval Initial Status Intake 2]@row +…
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
