-
Project Health Based on task completion vs project completion
I am trying to determine a way to communicate/graphically represent project progress based on today's date in relation to the start date and projected end date of a project. So if we have a 90 day project and we are on day 50 I want to see Project Progress of 55% I already have a data point for Task Completion percentage…
-
Linking smartsheet cells to Google sheets
Can we link a particular set of cells or values from Smartsheet to a Google sheet? If yes, then how can we do it?
-
Hyperlinks in Smartsheet
Is it possible to configure the Hyperlink in Smartsheet to open a local program in my computer like what we do normally in Excell ?
-
What Best Practices are there for a roll up master sheet
I have two Smartsheets and using cell linking have certain information linked to another sheet. I have it working but I am wondering what "Best Practices" are out there for this type of sheet. I appreciate any comments and thanks in advance!
-
Datamesh to Update Engagement Progress for Coaches and Clients
I run a smartsheet for tracking coach/client engagements. There are typically 6 or more sessions in an engagement. Neither coaches nor clients can have access to the sheet. I need the coaches to report the dates of each session in the engagements. Due to the nature of this environment, coaches can report any number of…
-
Linked Cells hindering form entries
Hi, Facing a problem with form entries on sheet with a bunch of empty linked cells. The webform entries go right to the bottom where the links end. The linked cells are important as plenty of info will be added to it in a single day and it becomes quite cumbersome to keep adding new links as we go. Is there a workaround…
-
Auto Number Columns Based on Other Column Input
Is it possible to link the auto number format to data in other columns? For instance, if the user selects a particular product type in a form (Soda, Water, Juice), can I create an auto number column format that looks like Soda-001 or Juice-001? Thanks
-
Linking Cells from Columns to Rows / Transpose Paste Special
I am trying to copy data from a source sheet to a destination sheet. The data on my source sheet is in columns, but I want it to be shown as rows on my destination sheet. I have tried to link several cells at a time, but it only links one cell - not the group of cells. So... I tried to bring in over as column to column and…
-
Suggestion: don't break cell links when moving row to another sheet
I'd like to make a suggestion - I just moved a few hundred rows of data with intricate cell links to another sheet using the "Move to Another Sheet..." option. All of my cell links were removed without warning. I would like to suggest that either the cell links are not removed during this action, OR a warning pops up to…
-
Project Management Best Practice Ideas?
Good Morning Smartsheet Community! Does anyone have any best practices / suggestions they could share for multi-project management ideas? We are currently using a Report that pulls rows from the "Assigned To" column across all project sheets in specific workspaces; However, while it serves the purpose, it isnt visually…
