-
Multiple vendors and corresponding part numbers
We are using Smartsheet to manage inventory. We purchase the same materials from multiple vendors, depending on pricing and availability. Is there a way to list the multiple vendors with their corresponding part numbers without indenting lines for each vendor below each and every item? The time required for that solution…
-
Formula for SUM by the category
Unfortunately couldn't find the solution here. I'm just looking for a formula that will allow me to count total sum by the category of a product. Basically, I have two columns: first is the Dropdown list with the category of a product, and second one is the Text/number column with the bid amount. What I need is a total sum…
-
Formulas and Reports
Hello everyone This may be a simple fix; however, I am fairly new to Smartsheet and any insight would be appreciated. I built a report that is linked to three different sheets. They were originally imported from Excel that way the formulas would carry over easily. When I pulled everything together, the three rows that I…
-
Reminder email subject line
Hi, is there a way in Smartsheets to setup a reminder with a more meaningful subject line. We track all our sales on a Smartsheet that will send an email Reminder to our Sales team one month after a sale is made to ask the customer, specific questions. These are in the reminder email. That's great, but the subject line…
-
Restrict to List values only
I noticed when I create a drop down list for contacts and select "Restrict to list values only" it works great in the main sheet, but when I view the same column in a report it is not restricted to list values only. All the contacts shown on that sheet also shows in that list. Am I doing something wrong? or is there a…
-
New Template(s) for The Public
I want to get this template to smartsheet for the community. Its for a family event with multiple data such as room availability, price, tax deduction, package and room assignment with form. Don't know how to donate this, but I would love to as its great for family get togethers. Won't do another one for 4 years cuzz it…
-
Sum columns for each month
I would like to summarize the cost of each month in the current year. columns for each month and year. I do not get the formula: =SUMIFS([Totalsum eks. mva]29:[Totalsum eks. mva]1403; Start29:Start1403; MONTH(@cell) = [Årlige utførelser]28; YEAR(@cell) = [Måneder for utførsel]28) Please come with suggestions
-
Enhancement Request: Sights Auto-Refresh
We have created a departmental dashboard and we're displaying it on a 40" LCD. It looks completely awesome and we are now the envy of all other departments... BUT, the screen doesn't automatically refresh. We created a script that automatically refreshes the screen every 5 minutes and that is working to update the data,…
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
Automated Row to bring up
Is there a way to automatically bring up rows that are in the bottom of the sheet? for ex: bunch of tasks that are live, done and on hold respectively. Is there a automated way to bring the live rows up, done rows at the bottom and on hold rows in the middle? I can do this with a report but was just wondering if I can…