Discussion List
Searching a sheet from a workapp
We have a Workapp for our field personnel to look up information from their phones as they do not have computers. One of the items in the workapp is a sheet with requirements per location, and we have over 1300 locations. Our users are unable to use the search functionality on their phones unless they have admin…
Restricting views in Dynamic View by filter
I have a smartsheet that contains task records for for different departments. I would like to create a Dynamic View for each department that everyone in the specific department can see that only contains the records associated with that department. I can create the filter without a problem, but when I try to Restrict view…
Request Approval Workflow for Entire Sheet
Hello, I have a sheet that has multiple columns with a checklist. Once all cells have been checked, the sheet needs to be sent to the department manager to review and approve it. It seems in the request approval workflow template it can only trigger by a specific field. Is there any way to do this? Or, maybe with one…
User data reports
We've been trying to build some insighful anaylicts for our leaders and I would like to show consumption (views) of dashboards and sheets, but I want to be able to separate internal users from externals. This analytic is a bit manual since when downloading the Activity Log, I'm not able to separate all the internals from…
CountIf between two numbers
I would like to count how many people scored between 99.5 and 99.9. Here is my formual. =COUNTIFS(Janury2:January12; >=99.5; January2:January13; <=99.9)
Free Slack
Hi, How to calculate the free slack on smartsheet?
Spell Check
I would love to see a spell check function. It would significantly cut down on issues relating to typos and other erroneous information.
Automate create email that won't immediately send
I'm wondering if it's possible to do something similar to what excel does, where we can program a button that once pressed creates an email with a specific template but won't send until clicking send like a normal email. The idea is that it would populate an email template based off the information in my Smartsheet to…
I am sure this might be a stupid question!! Why can this simple workflow not be executed hourly?
The Action column is a dropdown list. I also tried by changing the column to a text field. I keep getting the error about workflow timing is unavailable.
Comparing Emails in different sheets
I am using Smartsheet, to collect data on some challenges that my department would like to conduct, and there will be four challenges a year (one for every months) for the participants who registers (registration is only once per participant) First sheet (Registration Sheet) collects the registration information via form…