Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
New Notifications Design
We had working notifications set up in the past which would allow us to create notifications based on rows instead of columns. Now it seems a user will get a notification if anything on the sheet changes instead of a notification for changes to a specific row, which can lead to hundreds of useless notifications. Instead of…
advancing dates (roll over)
I have a number of simple tasks that re-occur regularly. Is there an easy way to roll due dates over monthly, quarterly, or yearly?
Sheet Summary
I have a sheet that I created as a log essentially. What I'm wanting to do is create a "report" that summarizes the data. As an example, I want to report total records, smallest number, largest number, and count of records with a specific condition. How would I go about doing this?
Smartsheet Filter Won't Share
I clicked on Share filter on my worksheet, but my team members can't see it. Any troubleshooting ideas?
Some of my parent rows are grey background, some are not...
Hi, I'm trying to figure out why some of my parent background are grey, and some are not. In the page: https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows about 1/2 way down, under "Expanding and collapsing.." both "Administration" and "software engineers" parent rows are grey background. But in…
Plus or Minus based on text
I am currently setting up an inventory management sheet that has a webform. I want to be able to have data updated based on one column. What I have is a column that is Shipped / Received. When completing the form, if the user chooses Shipped, the QTY column displays -10 and then takes this away from total stock on hand. If…
Stakeholder Management template
Hi there, I found some Stakeholder templates I'd like to use: https://www.smartsheet.com/free-stakeholder-analysis-templates When I click download the free template - it downloads an Excel file. In the file it has a button "Click here to create [template name] templates in SmartSheet". All it does is open SmartSheet. No…
Sum of hrs utilized per client
Hi Smarties, I created a time tracker with each column with drop down list for different clients. 1. I want to sum all the hours used per client and to appear in one cell per client, so I can link the cell to auto populate. I am familiar with step 2( cell linking). Can someone suggest how to run the report on a sheet with…
Announcements
Hi! I'm looking for some way to make an announcement on a sheet/report/sight when it is opened to let my users know about new functionality/requirements/processes instead of sending a separate email letting them know about the changes... Any ideas/suggestions for this? I need something bold and eye-catching. Preferably…
Date checkbox formula
Hello, I have a column of dates which are showing when an item expires. I want to have a column with a checkbox and a formula in it that will tick if the test date less 365 days is within the current month of todays date. So basically the test date less 365 days, and then checking if that date is within the current month…
