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 2017 Posts
Archives for April 2017
Discussion List
Assigned To fucntion
Hi, Can I assign tasks to more than one people? If so, how to do that? Thanks.
Workflow Automation
I am sure this scenario has been discussed elsewhere. However, I was not able to find it. I am trying to create a workflow using Web Forms. When an employee fills out a request in a Web Form I would like to automatically send that Web Form (with an additional dropdown field 'Yes'/'No') to the employee's supervisor for…
Date column
Hi - I need some assistance. I have a column with a given date. I have another column which will need to be that date plus 16 weeks. Is there a formula I can use to add that and get the correct future date?
Sharing part of a sheet or creating a new sheet to share linked to the other
I want to share a new sheet with only certain columns on it with a group but want the new sheet to automatically update when I make changes in my other sheet. Is this possible? Or can I share certain columns with a group? Thanks, Kristina
Brand alert/notification emails
Is it possible to brand our alert/notification emails? When I manually send an email from a sheet, it displays nicely, with our logo across the top, and I can choose a vertical format. When I get an alert/notification email, the display looks completely different, and the Smartsheet logo is at the top (instead of our…
Make "Done" box clickable in Card View
The Kanban/Card view is one of the best features in Smartsheet. However, when I look at a task list in Card view and I complete a task, I want to simply click "Done". Instead, I have to open the card in Edit view, then click the box, even though the box is visible on the Card on the board. It would be great to have the box…
SUMIF across multiple columns
Is it possible to run a SUMIF formula across multiple columns? Thanks Hugh
BUG: Parent % incorrectly calculated when using "elapsed duration"
A useful feature of SmartSheet that we often is "elapsed durations", e.g. instead of using 30d to indicate "30 working days" you can enter e30d to indicate "30 calendar days". ( for more info search for "elapsed" in this article). We use this a lot for durations that need to ignore holidays and weekends. The problem is…
Column Heading Search
Is there a way to find all the sheets that contain a text string in a column heading? I have 20 sheets that were all made with the same template (not ideal when you think of a new enhancment to the template--this has to be reflected in every sheet made with the template--a topic for another discussion/suggestion).…
Drag Fill Formula Horizontally
I am trying to find a way to drag fill formula horizontally so the formula updates the column name in the fomula as it is drag filled horizontally. Drag fill horizontally only copies the original formula across the cells... Am I missing something or is the drag fill function only posible if you drag fill vertically. Thanks