-
Work week & calendar days on the same sheet
Hi folks - can anyone tell me how I can have a combination of start/end dates that have standard work week durations (Monday thru Friday) as well as efforts that take weekends into consideration (all calendar days)? I know how to make the Gantt dependencies reflect one or the other but cannot figure out how to make 1…
-
Weeknumbers
Hi Smartsheet! It would be nice to see what weeknumber it is along with the date of the first day of the week in Ganttview. /Martin
-
Trigger notification/update request based on time elapsed since last comment or action on a row
We're using a ticketing system and trying to find a way to trigger automatic update requests when a ticket/row has been unacknowledged for more than 12 hours. Currently we're using the comments feature to post updates to the ticket across shift changes. How can I set an alert to go out if there has been no comment on a row…
-
Merging Cells
Does any know if you can merge two or more cells in the same row across two or more columns? I want to add a lengthy Confidential and Copyright footer on the bottom of a Smarsheet (within the sheet itself) however at this time all I can do is to paste it into the widest single cell available.
-
Automatically Adding Subtasks
I am working to create a Kanban Sheet and Cardview for continuous projects that we do in our office. We have the same subtasks associated with each client through 3 various phases. Is there a way that when I add a new client or Primary/Parent Task, that the same subtasks are automatically added? Thanks for your help!
-
"Publish User" when using Microsoft Teams.
When a user makes changes to a cell in a smartsheet from inside a tab in Microsoft teams (either in the Teams app or in the Teams Web Client), when looking at the Cell History the cell changes are logged as belonging to "Publish User". Is this the expected behavior or is there another way to make sure that the changes are…
-
Project Plan views / Task assignee see's just their tasks
I have read posts where it says to use project plan FILTERS or create one off REPORTS to execute this requirement. This seems inefficient and each option lacks what the other provides. NEED: I want an all in one feature within a project plan where I can set 'resources' view permissions based on when they're assigned a task…
-
Checkbox checked, cancel RYG
Hello, I have created 3 columns for the RYG, if the project is in the early stages the color green will show, if it is due within 4 days, yellow will show, and when it is due in 2 days red will show. Now I have a checkbox for the employees to click if the work is complete and I want the RYG colors disappear when they click…
-
SheetNames appear differently in SSIS compared to SmartSheet
Hello, I am trying pull the information from Smartsheet Dynamically using SSIS. I see that the Sheet Names in SmarSheet is different to what I see from SSIS ODBC Source. For Example : Names in SmartSheet Displayed Name in SSIS * 801 Centre Road 801 Centre Road__8524479023343492s_(Home) * Canterbury Road Canterbury…
-
"Save As New" doesn't retain Auto data...
I use a separate sheet to track projects in each calendar year. This means I need to carry over partially completed projects rows from the previous year's sheet to the next year's sheet. I've used a "Save as New" to duplicate the sheet, formatting and data, but my "Submitted" column which contains the "Date Created" now…
