-
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.
-
Does 365 / One Drive help the attachment process within Smartsheet?
Hi, Our Company has just installed Office 365 to all laptops. We did this for various reason: 1. We didn't want anyone saving work to their C drive and losing it if a virus struck (so everything that isn't saved to Smartsheet is saved to One Drive. 2. We wanted to ensure that all documents can be accessed from any laptop/…