-
Can't Print PDF of Gantt View
This project printed fine 2 weeks ago... now I can't print a PDF of the Gantt view. Grid view prints OK. Export to Excel and PNG work fine. It's not all that big... 67 lines. I've tried print entire sheet, selected rows, scaling or not scaling. Any ideas?
-
Is there a way to lock certain items in an update request
I am wondering if there is a way to lock people from editing in an update request certain fields or if I should not have them in the request at all? Please let me know.
-
Adding Time Values
New to smart sheet but couldn't find an answer to this question! Is there a way to add several time values to a total (ex. :15 + :15 = :30)? My goal is to sum all overtime minutes worked during the week into a running yearly total. On my spreadsheet I have a Total YTD Hours Column, A column for each day of the week that…
-
Linking to another sheet when a certain word is used
I am trying to get 2 sheets to work together. Meaning when I have a certain word or phrase I would like it to link to another sheet. How ever it can only be that word or phrase or nothing else. I need help Thank You
-
Resizing an Image
Is there a way to resize an image that has been inserted into a Dashboard? I am able to increase the size of the Image Widget, but the image is still not large enough and does not fill the widget area. Need to know if I can manually resize the image
-
Increment dates for new year
I have an existing sheet which contains a schedule of annually recurring tasks. I saved a copy to create the new year's sheet and now need to update the dates. Is there an automated way to do this?
-
Dashboard - Charting how many checked out of total boxes
I have a sheet that has checkboxes. I would like to be able to make a chart in the dashboard that shows percentage of how many checked out of total. I have a count for the checked boxes, but no total to reference. How would I go about this?
-
%Complete to be automated
I am trying to work on my sheet to get the % Completed to be automated. How can I go about doing this?
-
Creating a Task Tracker for Multiple Leaders
I manage a large group of leaders and locations who all are completing similar tasks throughout the month and I am looking to track progress without going back and forth via email. I have created a task list for each location as the parent and each specific task as sub-tasks and then assigned them to each leader. When I…
-
cross-sheet duplicate search
Thanks in advance for reading this :) I have multiple inventory sheets, each has a column with a formula to flag duplicates within a specific column: =IF(ISBLANK([Serial Number]1), "blank", IF(COUNTIF([Serial Number]:[Serial Number], [Serial Number]1) > 1, "yes", "no")) Form there, I apply some simple conditional…