-
Gantt Chart view for Daily / weekly / monthly Scheduled works
Hi all, We are new to this amazing product. We have separate 9 sites that have numerous different types of scheduled maitenance required at different times. Is there a clear way of displaying this in a gantt chart or spreadsheet type of format? example - Daily clean, weekly service, monthly polish, yearly audit. Thanks in…
-
Color Formatting
I have been noticing that my color formating occationally changes. I have one sheet I am working on that I color cordinated parent and children rows. Frequetly while editing, expanding and collapsing row, some cells will revert to white. Is there a reson for this, something I am doing wrong? Or a way to prevent it?
-
When will the API get some attention?
I'm using the smartsheet library, and it works pretty well, except that checkboxes always return None, no matter the value. I submitted a bug to the repo on github, and linked it to some other folks that noted the same problem on StackOverflow. For the tool I'm trying to build, I really need that feature to work, or at…
-
Formula Syntax Help
Hello, I am creating a sheet to track calibrations for the equipment in our department. I saw the function to add months to a date from another cell https://community.smartsheet.com/discussion/smartsheet-formula-syntax-help =IF((MONTH([Purchase Date]1) + 9) > 12, DATE(YEAR([Purchase Date]1) + 1, MONTH([Purchase Date]1) +…
-
Lead time Formula
Hello, I'm trying to figure out a formula or a way to make 2 cells work together and have the results in a third one. Here is the situation. this sheet is for procurement of items and their lead time to order. Example: in one cell we would put the date we would like the item to arrive onsite and in another cell we would…
-
Predecessors without adjusting date?
I've searched the community/help and haven't found a good solution so I'll ask here. There are tasks that have proposed start and finish dates. I have a duplicate task that will show what the actual start and finish dates are because of delays and such. Currently the duplicate has the same start/finish as the original and…
-
Grammar/Spell Check Request
Can I request for spell check? This hasn't been an issue (or at least not raised) and I would like to keep it that way. The Chrome browser option isn't so user-friendly; no 1-click scan or doesn't automatically show misspelled words.
-
How do you link an entire row?
I have several detailed gnatt charts for each of my projects as well as my groups projects. However the VP of our department would like to see a single gnatt that would only show all of the projects in a single gnatt. On this single gnatt it would only show the status of the Parent and not its childern. This way he would…
-
Date Formulas
I need to keep track of the day an item is approved. Is there a formula that I can use to generate a date that a check box is checked off?? Tiare
-
Column headers not aligned
My column headers recently became misaligned. I have attached a screenshot. This is only happening on some of my sheets but not all. Any time that I create a new sheet this happens as well. I am working on a Mac and using Safari. Note: When I use Chrome on the same Mac, I do not experience this issue.