-
Formula to count cells in a column if box is checked
I'm attempting to create a formula that will count the number of cells in a column from range in another sheet, that only includes the cells with a checked box. In other words, there are two columns to include in the count from my Communication Tracker sheet: Done -- checkbox column and Department -- dropdown column with…
-
Re: Task Alerts
I am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up To do this I use a form to add new tasks and then included the following columns in my sheet so; * a date column for when activity is due…
-
Select a user defined value for a default in a form
Hi, I have an inventory sheet where users are putting products in a box, the user would like to minimize the number of clicks as they are moving large number of products a day but these products will go into several boxes. is there a way to have a form look at a value the user maintained in a table, (box number), then have…
-
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
