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
Images from Link to Other Sheet
Currently, when you double-click on an image that is linked from an inserted image on another sheet, SS opens the "Link" dialog. Wouldn't it be better if the larger image preview opened, like it would on the source sheet?
Linking Cell Values From a Cell With a Formula
I am trying to create a workaround using the cell linking function in order to avoid circular references. In the picture below, the Premium column contains formulas calculating the appropriate total. Is there a way to have the Bound Premium column show only the value from the Premium column without carrying over the…
Search function errors
Anyone else having trouble with the search function? Just started for me.
Formula help...
I've tried a formula that seems to work, in that it doesn't give me the lovely "Unparseable" or "Missing Operator" message. Here's the scenario: If Column A (text column) contains "These words" then Column D (date column) = Column B (date column). Column A does contains the needed words, and Column B is a date. But Column…
Formulas
Hi I need to create a formula whereby the number of checked boxes within a column are subtracted from a certain number. Is that possible? Liz
Graphical display of the indent level
One feature I really feel the need of is the possibility to have graphical display of the indent level of the rows. Since I'm working with big files of data, sometimes I don't have the father row and the children ones (which have been indented) on screen, but I have to scroll the sheet. When working with multiple levels of…
Formula Help
Hi. I am a project manager for a design build company and I am creating a template to use to forcast the labour required on a job that automatically decreases based on the percentage complete. I am wanting to add a formula to one of my sheets that will automatically populate up to 4 column cells based on an option chosen…
Images in Dropdown list
I have a dropdown list that contians three companies to indicate who owns a requirement in a requirements accountability matrix. This works fine but now that Smartsheet can have images in a cell I was wodering if I could assign an image to each option in my dropdown list? So, when I select a company from the drodown the…
Attaching a Smartsheet Project Charter
I have a smartsheet that lists all of my active projects in a one line listing. I would like to attach the project charter to each project in this sheet. Is there a way to do this besides exporting into excel and then attaching?
Mechanize Alerts?
I'm linking cells between two sheets A and B. When my project manager changes a row's start or end date in their sheet A that links to my sheet B, can I have an alert triggered by this change to notify me via email? Is there a better way to achieve this type of mechanization? Another way said, once my PM is done with a…
