-
Help! Percent Complete not calculating
I have a project plan that was sent to me in a Excel spreadsheet that I'm trying to import into Smartsheet; after some trial and error, I've fixed up the fields but even with duration, start, end date and predeccesors enabled, I cannot get the % complete column to populate.…
-
Gantt Print Problem - Can't choose columns to print
Anybody having problems with their "non-licensed" users not being able to select the columns to print in a Gantt view? The "edit" button for selecting columns to print no longer works. I'm wondering if the recent software update has broken this functionality.. We receive an error that says "An error has occurred in the…
-
Documents not uploading or downloading
Hi All Is anyone else having an issue with uploading or downloading documents to/from their sheets? It is nearly crippling me here as i'm losing important documents as it appears to have uploaded and then it just disappears or won't upload at all. when i click to download, i have to try 2-3 times before the document…
-
Count Unique Values
I have a master sheet that is essentially a list of all the schedules we currently have dealing with projects. Each project has its own project number. All i am trying to do is get a number of the projects we have scheduled to compare to the actual number of projects we have in our queue. Now for the tricky part. Some…
-
Automatically move rows?
Is it possible to have rows move automatically from one sheet to another (to make room on the first sheet) when they are over 8 days old? I am doing it manually right now, and that means I have to do it every few days.
-
Sheets Showing up in Search
Is there a way to prevent a sheet from showing up in a search? I have a handful of "behind the scenes" sheets that appear in the search when my team searches for something. Is there a way for a sheet not to appear in the search? (That is, just show the sheets that they will use, not the "behind the scenes" sheets?) They…
-
Marrying 2 sheet datasets into 1 row?
Hoping someone might have come across this scenario. I have a three-step process where a phone scheduler calls to gain info from the client, then a field rep needs to go onsite and gather info followed by a report generated from both parties. A primary key for both parties inputs will be a Policy # The phone scheduler will…
-
Use "Created By" auto generated field as a "contact list" for use with approval workflow
I have a form that is use to submit travel requests. I would like to set-up an auto-field that captures who the form was "created by", rather than having them enter their name into the "contact list". I was hoping to use this to then send an auto-generated workflow to this contact. However, I believe workflows only work…
-
Insert row does not auto-fill
I thought this worked before, but maybe I am mistaken. When I insert a row (using the right-click menu, the row drop down, or the insert key), the formula from above and below the new row do not auto-fill. I really don't remember seeing that before. Craig
-
Command D not working or user error?
I recently switched to a Mac and am trying to get all of my new shortcuts down and I cannot get the command-D functionality to work. I have tried it on index/match formulas and simple arithmetic formulas as well with no luck. When I have a cell with a formula, I am highlighting that cell and pressing and holding command as…