Need help in converting the data sets to "K"s and "M"s
Trying to build bar graphs with large set of data and looking for help to convert the values to K's and M's. The Dashboard has a lot of key information that I would need to represent and hence it is congested for me to write all these numeric values as data values
I sincere appreciate any help to round a number to "K"s and "M"S asap.
Answers

That would have to be done on the metrics sheet. You would take the result of whatever formula you are currently using and divide it by 1,000 or 1,000,000 accordingly.
=COUNTIFS(..............................................) / 1,000
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!