-
Default Font Size and Type
Is there any way to set font size and type to default on every sheet as something other than Arial 10?
-
Return 1st column value if 2nd and 3rd column is blank
Hello, I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blank, if not return the value from either 2nd or 3rd column. These columns contains dates by the way. Sent (1st) ; Won (2nd) ;…
-
Master Sheet with Subprojects Inside
Hi! I am trying to create a Master Project sheet that would include subprojects inside of the same sheet. Basically so I can track the dates and overlapping of tasks in the subprojects. Is this something that Smartsheets can do? I know I can do it in MS Project and just add each subproject as it's own task in a master…
-
Report Builder Problems
With the recent (Sept 19, 2019) update, non-licensed users no longer have the ability to update their Report Builder within SmartSheet. This poses a significant problem for my company, as we have multiple licensed users and ~100 (non-licensed) individuals who execute the tasks assigned. Am I correct in thinking that each…
-
Creating a new project from a template and updating row information using Zapier
Good afternoon. I am currently using Zapier to automate the creation of a project sheet once an initiative gets approved on a log. The current configuration is the following: * New initiatives are captured into a sheet called "Initiatives Log" through the use of a form * Approval of the initiative is captured on a column…
-
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…