-
Weekends
To enter WEEKENDS as typical non-working days, and as to not have them counted in schedule durations, we simply go into EDIT PROJECT SETTINGS and make sure Saturday/Sunday are not checked. This is great throughout the duration of the project. But what do you do when you need to have a crew work through a specific weekend…
-
Exporting/Importing Google Sheets Not Working
Hi, Exporting to Google Sheets has not been working for about a week. There is no error message, but the dialogue box that pops up no longer has the "open Google Sheets" button and nothing actually gets exported. While trying to investigate the problem, I tried importing from Google Sheets and got the error message, "API…
-
Executive Update Templates - stoplight
Does anyone have any good executive high level templates you can share? One is the stoplight approach.
-
RACI Matrix
Does anyone have any good raci matrix templates they can share? I see the attached come up and reference smartsheet but can't find template.
-
Referencing other sheets
Hello, I have a sheet where I want to add totals in 7 other sheets for January - December for several drugs. When I get to February, it tells me I am at the max for references. I think it was 15. We have 7 squads...each squad seizes many drugs per month. I am trying to get the grand total of the drugs for all 7 squads for…
-
Reset auto number column
Hi All, I am not able to reset my auto number column recently. I followed the instruction at the bottom of the page:https://help.smartsheet.com/articles/1108408-auto-numbering-rows#create But it no longer works. I did it before, but not sure what changed. Thank you all for help Edward
-
Celling Linking-Multiple rows
I need to link about 50 cells in my Inventory sheet to the SAME cell in my Inventory Price sheet. Can I do that as a group? I tried selecting all the cells in my Inventory sheet, then selected the linking option, navigate to the Inventory Price Sheet and select the cell I need linked to ALL 50 cells. Using this process it…
-
Formula that takes a Start Date from one column and calculates number of days populates another colu
I have tried a number of formulas in an effort to - enter a date in one column / row and have it calculate out 30 days and self populate a date in a different column / same row . This date column is already part of another calculation dependent on a completion date to give me how many days past due . I have a check box…
-
Feature Request - Cell History Graph
For all of my projects I need to track the overall % complete for the project and individual areas. I currently have Smartsheet calculating this information and displaying as a % in a cell, but I would like to be able to show how the % complete has trended over time. Is there a way to show the individual cell history as a…
-
Avoid Overbooking a Training Facility
Hi, When creating a project grid for training events, I add a column named "Venue". In this column I provide the name of training facility where the training needs to be conducted. Hence, I need a way to be alerted when using the same venue more than one time on a specific day. Because, obviously, i cannot run two…