Hello Friends,
I have a problem that I am hoping is an easy overlooked solution. We are trying to summarize our sales numbers and I cannot figure out the best way to do it.
We have a column “ARR” that lists the revenue for every project that we take on and I want to be able to produce a report that shows me the number of projects that are 0-10k, 10k-50k, 50k-100k, etc.
I am sure that this is something very easy to accomplish natively but I can’t figure it out.
Help?
Thanks
Hello @ChrisH2 ,
It seems like you need a kind of Vlookup formula. I’ve recently run into the article describing this (check out the VLOOKUP example and template section).
I just mention here an opportunity to work with your board as i’s a spreadsheet with the help of the Smart Spreadsheet app. It auto-imports your board into a spreadsheet, and then you can try to play with Vlookup formula. We’re a few days away from rolling out the feature that allows you to add columns with calculation results on a board from a spreadsheet.