-
Whom should I contact...
...to get my "Account Executive - Expansion" to STOP emailing me?!?!?! I have repeatedly asked this guy to stop with his sales pitches. He has never answered a single email from me when I request specific information (ex: I would like some pricing information on Data Shuttle...) yet he continues to send me "exciting new…
-
Convert Numbers to Text so I can show a range keeping the comma delimiters
I have two columns of data showing prices, say $1,100 in one and $2,200 in another. I want to display this as a range in a report as "Your price is $1,100 - $2,200". I used this formula: "$" + $[Report Low Price]@row + " - $" + ($[Report High Price]@row which returns "$1100 - $2200", how can i have it include the comma…
-
Cell Linking not working
Good Afternoon, I have a report which collates all monthly figures from each Months Tab, and links them into a Detailed Yearly Report for my figures. This is starting from 2018, but ive got down to March 2019 and now the Linking doesn't appear to work. No matter how I do it, the link doesn't show inside my column. Is there…
-
Lookup Columns Between Sheets
Good day all I'm a newbie on the community. I'm trying to deal with a scenario which I thought was very common and assumed Smartsheet would have an easy way to deal with. The scenario is: we have a very simple sheet for managing customers. This sheet includes a customerID, business name, primary contact person, postal…
-
Dashboard with Filters - Best Practice
Hi all, I am pretty new to Smartsheet and will need your help to build a dashboard. What is the best practice to create one? GRID I have multiple salespeople in my team, each of them have their own grid. The grid looks something like this: ID | Date | Stage | Comments I am creating forms for them to fill up on a daily…
-
Forced to upgrade
I had recently bought a Pro plan and after about a month, a lot of the features that I had been using frequently (which was available on the pro plan) are blocked and now I'm being forced to upgrade to a business plan. I feel this is unethical... does anyone have any thoughts on this?
-
Automation for Request Update not working
Hello, I have created a Workflow Automation for when a Customer submits a Warranty Form into our Company. The Workflow has a condition where if one of the fields on a Form is Blank, then it should send back an Update to fill in the Blank Field. I dont want this to be a required entry on a Form for now. I have snipped the…
-
If this, then that formula question
Hello! this may be so simple, but I'm having a hard time with it. I want a few things to happen - if the Approx trips per year is blank: provide the sum of just the Registration price field & the Approximate travel field If the Approv trips per year is NOT blank: multiply the approx trips per year by the apprx travel cost,…
-
Sales pipeline with sort (need child/parent row stays together)
I have a sheet that has child/parent rows and which I can sort by dropdown list order (see below pics) So here are my questions: 1.) how can I have a report where it only shows the current user AND that the child/parent row are together when sorted in the report 2.) I want the sort to be "sort by dropdown list", is that…
-
Center of Excellence
If someone wants to subscribe to the Center of Excellence, can he/she do that without being a paid Smartsheet user, or does the person need to upgrade?