-
Sheet Column References in Equations
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get…
-
Ticketing Sheet: Update Request to Group?
I'm using the ticket template and want to use the update request feature. Currently it seems like the only way to do an update request is to assign it to a specific user, which doesn't make sense if you have an entire department working on tickets at different times of day. How do you request an update to a ticket (row)…
-
Multiple colors applied to one cell
I am pulling data from an Excel sheet listing resources. These resources (cells) are color-coded based on availability, training, etc. In a couple of instances, some resources might be available AND billable and, consequently, require 2 different colors in the cell (from the legend). In Excel, there is the ability to…
-
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…
