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 2015 Posts
Archives for August 2015
Discussion List
Notification only when their name appears
We have A LOT of data we use smartsheet for and it is easy to miss something with our collaborators. I would like to be able to set notifications only when their name is assigned something and not when the entire column of "assigned" changes. Any way to do this?
Removing Parent Rows from a report
Hello everyone, I am using Smartsheet to manage several projects, all on individual sheets, with a high level role up for managers. We are trying to create a report that goes through all of the projects in a certain workspace and looks for tasks that are past their due date, then outputs the project name, task and who it…
Help with an IF statement
Hi guys, I'm in need of some help with regards to trying to use an IF statement to manage Priority rankings. Basically, i have two columns that rank boht Criticality and Manageability, dependant on the score obtained across boht of these dictates the Priority ranking applied to a Risk. I'm currently receiving an #INVALID…
Count specific list items in child
I have a list of reports being sent to specific users as seen here: Location 1 - User 1 xxxxxx -- Report 1 Monday -- Report 2 Thursday -- Report 3 Daily In the "xxxxxxx" cell, I'd like something like this: M:2 T:0 W:0 T:2 F:0 to let me know at a glance how many reports someone is getting on daily basis. I can't spread the…
Link to Google Forms
Could not link to Google Forms - got the following errror: Error: getMe: Exception: Request failed for https://api.smartsheet.com/1.1/token returned code 400. Truncated server response: {"errorCode":1132,"message":"The token provided had been previously revoked.","error":"invalid_grant"} (use muteHttpExceptions option to…
Report Column Names / Labels are not same as Smartsheet Column Names
Hi, I have noticed on reports created from the original smartsheet that the Primary Column Label and automatic numbered columns don't have the same smartsheet column name. When you pick the reporting you want to include it uses the original default titles as opposed to column titles used in the smartsheet (if you have…
Notifications to specific employees
I have 10 employees. I have a month-end assignment sheet where employees are assigned to tasks. I would like to send out an automatic notification to the assigned employee when the task has been approved by management. Alerts - Reminders have the feature of sending the reminder to the actual assigned person, not everyone.…
Webforms
I have a sheet that I've already created and I only need non-smartsheet users to fill out the address column. Can I make my current sheet a webform and require them to enter data into an existing cell by selecting their names?
What is the "Created by" option supposed to do?
I have used this option for a System column thinking it would automatically populate the email or user name of the person (within my network) who submits a request by web form. However, all tests by several users of this functionality show the same "email address" - web-form@smartsheet.com when the request hits my…
SS and Google Calendar
Is there a way for me to BLOCK someone from being able to edit info from Google Calendar? I'd like to be able to show my field staff the details but not allow them to make edits.