-
Ranking Tasks
I work in the IT Department at a company. Another department assigns tasks to our department for software support for a particular application that they use. We would like for them to rank the tasks that they want us to complete - with numbers - 1 through 25, for example. If they create a new task for our team and assign…
-
Dashboard Help
How do you add a pivot to a dashboard?
-
How can I detect "Sheet - Create" using API
Background * We will be creating / managing projects in Smartsheet * Each new project is a new sheet, based on a template * I am designing integration to other systems that need to be notified whenever a new project or task within a project is created. * I can use a Webhook to detect changes within a project (sheet) * It…
-
Auto Close Tab/Browser after Form
Hello Community, I have been working on SmartSheet for quite a while now and I've created a form that helps my business in submitting the information that I can use to send tickets to our IT department. I've tried finding an answer to this but I couldn't find an answer. Recently I have created an excel file that directs…
-
Sheet count
I have an individual account which allows me 10 sheets. If I decided to delete a sheet after use will that restore 1 back to my remaining sheets???
-
Sales Tax Calculations
I'm looking for development help to calculate sales tax rates from a "Lat / Lon" entry in a Smartsheet cell and returning the correct sales tax rate based on that location to another Smartsheet cell, perhaps using the Pitney Bowes API tool. https://developerportal.pitneybowes.com/software-apis/gettingstarted If anyone has…
-
Filters on Reports
I am looking for a way to filter on reports the same way you can filter on a sheet. It seems that on reports you can only sort whereas sheets allow you to filter. If this functionality is not available, I would like to request it be added to the future enhancements list. Thanks, Steve
-
INDEX MATCH to OTHER WORKSHEET
Hello, I'm evaluating the use of Forms for a "field ordering" system from an Item Master Table. Best scenario is to create a form to request multiple items via a single submission (not multiple items in a single cell = less desirable data management), and also to have a confirmation submission email sent to an email…
-
Graphing Data
Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario: Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from a dropdown list), time of day (from a dropdown list), their location (from a dropdown…
-
Tick a checkbox depending on value of another field
I have a multi column Smartsheet that tracks items by date. Part of the functionality shows the number of days the item has been active:- =IF(OR([S.Status]5 = 3, [S.Status]5 = 1), TODAY(0) - [Start Date]5) There is also a check box column. What I would like to do is to automatically tick the check box if the number of days…
