-
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…
-
PDF exported report includes comments even though not indicated
Hi there, When trying to export a report I built as a pdf I keep on getting the content of the comment column too even though I have left the box for this option unticked. What can I do so the report exports into pdf without this column? Many thanks, Lesley