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
Changing default message in task update request
Hi. I would like to change the default message from: "Please update the following rows in my online sheet" to a different message. How can that be done for me only or the entire account ? (both options ok)
How to send a notification to a selected recipient
How do I get SS to send a notification to a contact whose name has just been selected from the list and entered in a webform? Like, when column [supervisor] is set with a particular name, please notify [selected supervisor] of this change.
excel import - resource management
I am trying to import an excel file that has tasks, start/end dates, assigned resources. The excel sheet (sourced from a ticketing system) will be sent to me periodically and will need to be refreshed into smarteheets. Objective: to show where and what the resources are over allocated. I have been informed of and followed…
Counting in summary reports
Hi All, I'm interested if anyone has found a good way to use sheets or reports to count fields meeting a given criteria from another sheet. In my particular case I have one sheet that lists (and links to) project sheets. I would like to have another sheet/report that counts how many projects are green/have a particular…
Dependencies - with time between items
This is the senario: Line 1: Start date January 1st. Duration 5 days Line 2: Start date January 15th. Duration 5 days. I want the two lines to be dependent so that line 2 can't start before line 1 is done. However, Line 2 should not start before the 15th. My problem is that if I create a dependency, the startdate of line 2…
Update Requests: Search by recipient and unplanned reminders
I am using update requests quite a lot, but they are not for recurrent type activities. I would like to think they would be recieved and acted on, so I don't set up reminders. My problem is that recipients are working across many production jobs, and not reporting activity consistently, using the Update Request system.…
Error Message "Error: this link is invalid"
When linking from Sheet1 to a cell in Sheet2 I am recieving the Message "Error: this link is invalid". What is causing this? The dates in Sheet2 are driven by Sheet1, BUT there are no dependencies that set up a circular reference. I am wanting to bring back start date/duration for information only. We have been having some…
dates on top of bar graph
How do I change the dates on the top of the bar graph to be weekly instead of every three months?
Bug in latest version of SmartSheet
Hello Smartsheet Community, I use the formula : =[Previous Week]1 - [End Date]1 to show me my variance each week when I status my smartsheet schedule. The latested update in Smartsheet broke my formula so that when I copy the "End Date" field into the "Previous Week" field it no longer shows as "0" when th dates haven't…
Alert when a row has not been updated in the last 14 days
A project lead has requested an alert that sends to him when a row (assigned to a project manager) has not been updated in the last 14 days. My attemtps at a solution: 1: Include the system column (Modified - Date) 2: Trying to apply conditional formatting to make it easily visible when viewing 3: Can't seem to work out…
