-
Score formulas
We are having a sales contest this month. The teams (Houses) entered their numbers and we are ready to Identify the winners for 1st, 2nd and 3rd place. I was able to identify the 1st place score (Highest Score) using the MAX function and the name of the House (Top Team) with the JOIN function. BUT, I cannot identify the…
-
Cross Sheet reference/"assigned to" allow multiple contacts per cell LIKE formula?
SS community - I need help. I have created a Sales Pipeline sheet for my sales team, sales stages etc which is basically it's own CRM. I am trying to gain metrics in order to keep the sales team members honest and report the truth to the leadership team. Challenge: Cross sheet formula (below) pulls correct data but when…
-
Pricing: A La Carte Apps
Smartsheet, you need you allow apps to be added a la carte to Business accounts. Restricting apps to Enterprise is unnecessary. It feels like nothing more than hard-ball sales tactics. While Smartsheet has helped our business organize our operations team, we are not happy about the divide between Business and Enterprise…
-
Report on all sheets I am part of as Assigned To
Many of our team members will be allocated to many different sheets. 1. Is there a feature how to make a report showing all sheets I am assigned to?, and as a continuation a report showing specific tasks in those projects, for example Gate Review, or Offer Submission? Those tasks are not necessarily assigned to that…
-
database
Hello, Smartsheet team! I work for a medical equipment sales company which is intereted in create a database of all our client’s equipment. We want to sort all this information out in order to eliminate paperwork. We need to apply different filters which allow us to manage the record of all this equipment. Currently, if we…
-
Sales Pipeline - Period View
Hi, I have a few sheets of Sales Pipeline for each Manager. I have brought all of the estimates sales data together in a separate sheet and created a Dashboard using this. However, I would like to only see data relevant to the particular Financial Year in the dashboard. Any suggestions on how to go about this?
-
Column Number Function
Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
-
IFERROR Formula
Hi All, Hope you're keeping well. I've recently started playing with IFERROR's and updating some existing sheets. I have a sheet that reports with each row being a week of the year. Many of the formulas for "Rows in the future" or in some case, "Rows in the Past" return DIV0 or similar errors which I'm trying to eliminate.…
-
Any Plans to add "Funnel" Chart to dashboard options?
It would be REALLY useful to be able to visualize pipeline via a funnel chart.
-
The Mythological Product Development Team
Once again, I have gone in search of what I would consider a perfectly logical and necessary function only to find that Smartsheet can't accommodate. When I call customer service, I receive the same answer every time: “We don’t currently offer that function, but we will submit this to our product development team and they…