-
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…
-
Date in a CountIf formua
I want a calculation that displays a summary of how many records have a complete date greater than or equal to 1/1/2017. Here is what I add to the cell: ="Unassigned: " + COUNTIFS(LOB:LOB, "ERx", [COMPLETE DATE]:[COMPLETE DATE], >=1/1/2017) Then I get an "Invalid Operation" messag and SS adds spaces to the date portion of…
-
Export List of People a Sheet is Shared With?
Is there a way to export a list from a sheet that shows the user's security level? And if so, can this list be imported to a new sheet so that each team member does not have to be added manually to the new one? This is not necessarily for a template that is used repeatedly. It is a group of about 150 people, various…