-
Hide or reveal a web form question based on answer from previous field
Is there a way to hide or reveal a question/text input field in a web form based on the answer from the previous question? For example, I am creating daily truck check forms for our paramedics and one question is "how many back rafts are there?". The dropdown list choices for them are "3", "Restocked", "Ordered" and…
-
Adding Workdays to a Formula
Hi SmartPeople - I am trying to create a formula that adds "work days" to a date. Example: I have a "Date Reported" column and a "Date Due" column. The "Date Due" column is a formula based column that should add a specific number of days (either 5, 10, or 20) based on a given priority in the "Priority" column. However,…
-
Assigned To Notifications Not Working
I have several sheets with Assigned To notifications set up and they are not sending emails upon assign. I'm hoping I'm doing something wrong, but I've searched these boards and it looks like I have it set up as suggested. Here is a pic of my settings. Please help!
-
Enable/Disable cells
Hello everyone Is there a way to make enable or disable a cells according to the values of another cell. A kind of conditional formatting with making enable or disable cells. Thank you in advance
-
Simplified Resource Management
Hello! I am attempting to develop a simplified resource management tool that would allow me to see what users are working on what projects/tasks based on the email in the Assign To column. I do not require the time allocation, just name/email and the number of assigned tasks across multiple sheets and workspaces. Some of…
-
Web mail notification
Hello, I am new to web forms and have a question. I created a web form, which a client will fill out to create a work order form, once the form has been filled out and it's completed, there is a link for them to enter their email address to notify them of their submission. How can I create an alert notification to the…
-
"We received a bad request" on Outlook Add-in
I'm an IT admin trying to install the Smartsheet add-in for my users and am being faced with the "We received a bad request" error when trying to Connect with Office365 in Outlook. I have tried putting the ?prompt=admin_consent string the URL to give permissions, as well as add the add-in to the Exchange admin center. I DO…
-
Calculate duration excluding Weekends
Afternoon, I have a smartsheet where I have a start/received date and a sold/end date. I calculate the difference to determine the duration however I need to exclude Sat & Sun (Friday if possible) in the formula and thoughts? =NETDAYS([Date Received from xxx]263, [xxx Date Shipped Out]263)
-
All videos simple - don't show realty use of training needs
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…
-
Feature Request - Sheet archiving offline- or Unlimited sheet limit.
Since I use Smartsheet for everything at work and home, the number of sheets pile up. One can get up to the sheet limit fairly quickly. I use Smartsheets for job tracking and article outlines so the number of sheets piles up pretty quickly over time. Some of the sheets I no longer use on a regular basis but want to keep…