-
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…
-
HYPERLINK API
We have been using HYPERLINK("http://website.ws/links", "Click Here") in both excel and google spreadsheet, and since we need jotforms integration for client our current links in smartsheet is very long and creating hyperlink manually for each row is a terrible ordeal. It would be great if you add HYPERLINK("URL", "Text")…
-
How to set recurring reminders
I have been searching through the posts and found this formula: =IF(Complete4 = 0, TODAY(), “”) using my own column names. Each time I've tried to accept the formula, I get this error message: unparseable. Am I missing some of the formula (my Excel is rusty)? I want to have an email reminder sent daily until the task has…
-
Taking quarterly goals and putting them into Smartsheet
I have a general table I use to keep track of goals for a sales team. I think they're relatively simple, but I'm having a heck of a time trying to get them into SS. The things I need to track: Goal value - numbers, for example $62,000 Actual QTD - numbers, for example $50,000 % to Goal - numbers, Actual QTD shown in % form…
-
Commission Formula
Evening, Hope you're all well. I’m hitting a brick wall inserting a formula into a tracker for my sales teams commission structure which is being redone. It’s a tiered system whereby the salesperson will get commission in brackets until they reach target, and then a higher percentage on anything over target; (0.1% for the…
-
Sales Projections Sheet
Hello All: I'm working on a sales projections sheet and looking to create and easy to notice symbol, on target, below target, and off-target. What is the formula to be able to easily create this? Thanks in advance. MH
-
How to use COUNTIFS with HAS and match 2 Columns while counting multiple selections in dropdown
How to use COUNTIFS with HAS and match 2 Columns while counting multiple selections in multi select dropdown ? Solving for: How many "Devon's Corner" Leads do we have by Location Type - "Bar" or "Brewery".. If any or both of these options are selected, they should be counted as 1 =COUNTIFS({Brand Type 1}, "Devon's Corner",…
-
Day of Week instead of short date
Hello, I would like to have a formula in place that automatically selects a day of week based on the date we paste in the "Bid Date" Column. When 3/26/18 is loaded into [Bid Date] Column it produces "Monday" in the [Day] Column, and so forth... Is this possible?
-
Auto Save
I just noticed that all of my sheets are now auto saving. When did this start? Not sure if this is a good thing or bad thing.