-
Microsoft Project Import Settings
Hi guys, I have a client who needs to view an export from smart sheet in MS Project. It's quite a large plan of 1000+ lines, and whenever I import either the XML or Excel file from smart sheet into Microsoft Project (have tried versions 2010 and 2016), the dates are changed Microsoft Project. I believe this is because…
-
Auto fill gaps
Good afternoon, I would like to know if it is possible to autofill a gap by using a code in a formulary. For example: Code number 5678 - WALLMART STORE When the code is entered automatically a gap is filled. Is it possible ? Regards,
-
Using SUMIF when column is not blank
Hello, I am trying to sum only the values of the children in one column for which the corresponding cell from another column is not blank. I tried this formula: =SUMIFS(CHILDREN(Amount25)), (CHILDREN([Date Paid]25), NOT BLANK), but it did not work. Is it even possible? Thanks!
-
Locked is greyed out in pull-down menu
I have a spreadsheet that was shared with me. I made a copyu of it so now I am the owner. I would like to make it into a template, but prefer to lock the formula columns. However, even if I stand on my head, I can't get the the locking feature to become available. Thanks! Andy
-
Google Docs attachment Error 401
I want to attach documents through Google Docs so when I make changes to the original file, the attachment in SmartSheet automatically retains the corrected version (which it does not if you upload a file from your computer). However, when I select Attach, Google Drive, I keep getting the following message: Unauthorized -…
-
unintentional deleting of cells
My cells are being deleted simply by clicking on the cell and staying on the cell for about 3-5 seconds. How do I stop this nonsense? I have logged in an out several times. The undo buttom does repair it but obviously that is not a fix. Any suggestions?
-
Cell Content Replacement with IF Statement
I created a formula to automate the process to enter % Complete and Status Complete fields to match when 100% Complete. It is working the way I want on Project sheets for each department to apply formulas for "Not Started", "In Progress", "Complete", etc. When entering a new row the formulas don't appy the formatting.
-
How can I exclude a task(s) from my report if the predecessor for that task is not complete?
I have a dozen or so proejcts each with their own sheet. I've created a simple report that looks at each project and returns tasks that meet two criteria: 1. The task has not been marked complete 2. The task has a due date of 5 days or less. This report works fine, but it returns more data than I want to report on.…
-
Create a sheet or dashboard that shows all items requiring attention
My director would like somewhere to land that shows all the projects that are waiting on him to proceed. He does not want an email compilation; already tried that. Rather, he'd like to have a place within his Smartsheet account where he can click and see all the rows that have "waiting on Doug" chosen. Is this possible?
-
Adding previous time to project-sheet
Hi I'm making a sheet on my project started a little before the actual day I created the sheet. I want to plot in some activities which has occurred in the beginning of my project. However the calender provided is only 1 month back. Is it possible to add a month or two back in time?
