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 April 2015
Discussion List
Receiving "Invalid URL" When Attempting to Link Into a Share Drive Folder
I've scoured the interweb trying to figure out how to link from my Smartsheet into a share folder using an html link, and have tried several different methods, but keep getting this error message whenver I try. Any suggestions?
Include Parent Row for Email Reminders
First of all, thank you for starting the Smartsheet Community. It's been very helpful. I have a project tracking sheet. Each project has basically the same set of major milestones and target events. I have email reminders set up to notify me when these events will be starting soon. But since the parent row information is…
Adding additional tasks
Hi All, I have been trying to add a new task to my worksheet but can't seem to get it to work. I have tried simply copying and pasting and using the indent / outdent functions with no luck. The basic template only has a standard 3 tasks and I need a few more. Regards Andy
Replicating multiple worksheets in Excel
We use an xls file to manage our monthly staff rota. I want to transfer this to SS but we use multiple worksheets, one for each month, ie one for Jan, one for Feb etc. What is the best practice for replicating this functionality on SS please? Thanks. Michael
Money format in cell not working
I am using this formula to output a fee based on gross loss for insurance claim. The resulting total column shows proper dollar format when it is over $100,000 based on first IF statement. When it is either of the following IF statements, ie for losses > 500, or losses > than 0, then the "TOTAL" cell shows a dollar sign…
Copy column and cell locking
How to copy renamed column to a new sheet? How to lock a cell in the sheet?
Attachments and Outlook
Many of my attachments are emails in Outlook. Is there a way to drag a .msg directly from Outlook into Smartsheet?
Indent not working
For some reason my indent and outdent is greyed out and unavailable. I can't figure out what I am doing wrong. Any ideas is very much appreciated.
Feature Request - Ability to Email locked fields in the auto-response
We are attempting to use Smartsheet to aggregate some of our quality data. Users score customer interactions and will utilize a web form to populate a Smartsheet. The sheet contains formulas that calculate the actual scores (in a few categories). We need a way to get the results to the evaluator relatively quickly so they…
Seeking an Alternative to the Absolute Reference of a Parent Cell
Has anyone used a formula which can report a child's percentage of the total rolled-up in its parent without using absolute cell references? I'd like to avoid absolute references because I'd like the formula to be consistent all the way down many parent cells, which will have different absolute references to be used in the…
