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. Archived 2017 Posts
Archives for October 2017
Discussion List
Publishing read access sheet/report with common password
Hello all, We are facing a situation where we want to publish a report in reading mode to a group a people. We do not want the information to be public on the internet so the basic Publish is not an option and since the people only access to this information couple time a year, creating a managing a Smartsheet account for…
Count, sum, average
I use Smartsheet to track employee certifications. I'd like to determine the average number of certifications per person at each site/area. I'm able to use an equation to determine the number of certifications each person has, but that occurs in each row which throws off the average. In other words, =IF(Status1 =…
Progressive sumif formula for calculate invoice progress
Over the course of a contract, I want to track how much has been invoiced and how much is left. If possible, for some contracts I know the invoicing is on a cycle and should be the same amount on say a monthly basis. I have columns for each month listing the invoice amount Invoice Amount and a date column to be completed…
Project end date - Metric
Hi I am trying to create a metric for a Sight sheet to show countdown in days and another in weeks until a project starts can anyone help ? Cheers Neil
Sheet to sheet selective data transfer (for new rows)
I currently have two active sheets. The first sheet, we'll call "intake" and the latter "Projects". If I review a *new* row added to "intake" and determine I want to copy it over to "Projects", I need selective data from certain columns on that sheet to transfer to certain columns on "Projects". The columns do not directly…
"Sorry, notifications are temporarily unavailable but should be back soon."
For the past few days I've been receiving the following error message when trying to load the new notifications tray: "Sorry, notifications are temporarily unavailable but should be back soon." Any idea what's up?
Mobile version of Smartsheet
Hi All, Is there any way to open smartsheet on tablet with pure desktop view? Currently I can choose between browser mobile view or android app, but both of them has different behaviour to the PC desktop view. I have a two users that have to take notes quickly in many rows, while they're going through the shopfloor, so I…
Notification and Report of open tasks for all smartsheets
Is there a way to create a weekly notification that has enclosed within it a report for each user's outstanding tasks from all of our active smartsheets? In other words, I have 30 projects and in those 30 projects, Lisa and Dave have tasks. I want to remind Lisa and Dave each week of all the tasks that they have in those…
Autogenerating a report to send to an email recipient
From a report, I would like to auto-generate an email for a new row added. Victoria
Sending multiple rows in vertical format
In a report, is there a way to send to an email recipient two rows at the same time in vertical format? Victoria