-
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…
-
Rostering for Global Customer Support
Hi, I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources), who is on leave, time, names of the support person and who is on call. Also, includes our contractual obligations with customers in an easy display view to the eye. Do you think…