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
Gantt timeline doesn't match project start and end dates
Hello there I am a new user and am stuck! My Gantt chart doesn't seem to update project info from the start and end dates. Also the top bar of the Gantt Chart has irrelevant dates that I cant seem to be able to change. Not sure what I am doing wrong Attaching a screenshot . Many thanks in advance
Formatting lost when pasting to Word
When copying and pasting cells from SS to a Word doc, all formatting is lost including any highlighting, font changes, etc. Only the text can be copied and pasted over to Word.
Notify an assignee that the predecessor required to start work has been completed.
I am looking for a solution that will allow an email to be sent to an assignee informing them that their part of a project can begin since a predecessor was completed. Any help would be greatly appreciated.
Filter out multiple companies
I have multiple customers, some of the companies are listed more than once because they contain different data. But, I also need a filter to filter all of them out except for one, is that possible?
Add up prices in a column if checkbox is selected.
I have a list of parts and prices. I would like to have a total cost add up for the rows selected by a checkmark. Basically it is a parts list and I am trying to add up for a quick quote the items selected. Is there a way to do this?
Gantt chart on Mac OS while using Firefox and Safari
Hello, I have the problem that on the trial version its not possible to click in the middle of the sheet and pull the gantt chart wider. Is this a trial thing or is it just not possible to do it on a Mac OS while using Firefox or Safari? Kind regards Arnis
Due Date based on Priority and Date Submitted
Hi, Was just after a bit of help with a formula I am trying to produce. We have a sheet with a column 'Priorities' of Low, Moderate, High, Extreme. We then have a column titled 'Date' I am trying to automate our 'Investigation Due Date' by IFS formula. That is priority is Low or Moderate the Investigation Due Date will be…
Subtract weeks for lead time with notifications
I'm trying to subtract 6 weeks from my Factory Shipment Date (row 1) to give me lead time to notify Port Authority which is assigned to someone on my team. I have 15 categories/columns like this with 4 team members. The categories need a lead time of 6 weeks, 4 weeks, 3 weeks, 2 weeks, 1 week or 3 days. This is for a huge…
Automating Project Status
Hello, I would like Smartsheet to automatically assign a project status based on duration and number of days behind project. I have specifically been asked to assign a project status of red if the task is 20% behind schedule. Please let me know if you are aware of how to automate this in SS. Thanks in advance for your…
Filtering gantt chart
Hello everyone, My goal is to filter a gantt chart so that clients only see a portion of my task list when I export a gantt chart for them. Since I'm brand new to Smartsheet, I'm hoping to run my workflow by all of you to make sure I'm on the right track. I first assemble my master list of project tasks and sub-tasks. The…
