-
Feature Request: Alerts on Workspaces
I would like the ability to add the same Alert (Notification) to all sheets in a Workspace. I copy a project workspace (about 8-12 sheets) and want to have them initially set to notify me of any changes right away. Changing the frequency as the development progresses would be nice. I tend to do this on a sheet by sheet…
-
Webform question: uploading files to Box
Is it possible, using a Smartsheet web form, for the "File Attachment" widget to store the uploaded file to a designated Box.com folder? In other words, not as an file attachment to the Smartsheet row, but as a link attachment to the Box file? Otherwise, the user needs to first upload the file to the correct Box folder…
-
smart change of column name
Hi, i need to change several column names in my smartsheet. I have entire workspace built around this sheet, using it as data source. I have multiple reports that show/filter on this column, and if i simply change the name, reports stop working. is there a smart way to update column name everywhere? or somehow get a list…
-
Allocation for Project Manager
We are using Smartsheet with Resource Management enabled. We are tracking % allocation for employees and would like to do so for Leads as well. The idea is that the Lead would be allocated for the duration of task consisting of smaller subtasks at, say, 20%. We are using the Basic Project with Resource Management template.…
-
COUNTIF Formula for Week Of
I am trying to do a COUNTIF formula of a list of cells that contain dates to determine if any of those dates end up on a given week. I think I need to use COUNTIF and then have a > and < on the date but am not sure how to do this. I could also reference the Monday DATE() +4. Anyone have any ideas?
-
users feel intimidated by Smartsheet
I collaborate with many people who have no PM experience and/or prefer memo-style information over cell-based. Some people feel overwhelmed by the tool so they send emails rather than update Smartsheet. Beyond the training and show-me sessions we already do, how might I help people embrace Smartsheet? Do you know of ways…
-
Projects per sheet?
I have 10-12 projects each year that will use the same project steps. Is it better to create one sheet to house all 10-12 projects and seperate them using the parent/child relationship. OR, is it better to create one sheet per project? I'm also thinking about how this will report up to a Smartsheet Sight for status updates.
-
Alerts - Notifications to Groups
Is it not possible to set up a Notification alert to be sent to a Group? I only see the ability to send them to individual users.
-
Feature Request: Comprehensive Notification Setting
We need the option to set our notifications to include ALL changes, not just the changes of others. Right now if you subscribe to sheet notifications, the only way to get a full list of what changed is if you don't make any changes to the sheet yourself. Boooooo. Why can't I choose? Currently, if you have notifications set…
-
Display report data rolled Up?
Hi there I’m currently running an exercise where we are asking a group of 30 users 10 sets of questions each. Each set of questions has its own web form so there should be 10 responses from each user (300 separate rows in total). I have this working fine. The users have requested a ‘dashboard’ which would allow them to see…