-
Project Column Creaion.
Hi all, I have approx. 200 projects on Microsoft Project Server and now I want to migrates all these projects to smart sheet but unfortunately, a lot of project columns are not migrated to smart sheet and now my question is that how will I create a single column for bulk of projects.e.g Project ID column to show for all…
-
User Management - Enterprise level
Good afternoon, We've upgraded to Enterprise (still a bit of a work in progress) but I notice I no longer have access to the User Management area (I'm not a SysAdmin any longer). Is there a way for this access to be restored so it only shows User Management for the sheets/reports I have created? I am desperate to download…
-
Using decision symbols to change text
Please can somebody help me, I'm new to formulas! I'm trying to get text in a cell to change depending on what decision symbol has bee selected (YES, NO, HOLD) I managed to get it working with just 'YES' as follows: =IF(Graphic6 = "YES", "Includes GRAPHICS see schedule") but I also want different text "No GRAPHICS" to…
-
Zooming on Chart
Hi there, I am trying to zoom into the chart basically from the beginning of November 2017, til the end of February 2018... However it either zooms in WAY to far or not enough, so when i print it, it either prints 6 pages or just 1 but it is hard to read. Is there a way around this? Like maybe a scroll in to zoom? Thanks.
-
Formula %predicted by date and %Conclusion
Good afternoon. I have a question about the percentage during the project, because my% predicted on the date and my% Complete, does not hit when they are the same.
-
Smartsheet for Marketing
I am brand new to smartsheet, just trying it out to see if it would meet my needs. I run a marketing unit at a university, and currently use a system called Workfront for our project management and online proofing. Is there anyone out there using smartsheet for marketing? If so, what are the pros/cons you've come across…
-
Report not showing a row
I have a project plan with rows linked to a sheet. I am attempting to pull a report on this sheet, but the report is not pulling in all of the criteria. The project plan has a column titled "Tags", which has Milestone and Timeline. These tags are included on the linked cells in the other sheet. I Run the report to include…
-
How to make a Status row function like a Status Column
Hello! Is it possible to apply the properties of a column to a row? I want to be able to update the status of each column in a single row. I'm not able to identify where and how to do this; please see my attached screenshot. Currently, I have a column titled Status (circled in the screenshot). I essentially just want this…
-
auto date entry multiple columns
i have multiple columns in a sheet for various tasks that need to be completed (water, electric, etc.). the columns are a dropdown to pick from complete, in progress, not started. i wanted to insert a column next to each task that would insert the current date & time when the status was changed to complete. i attached a…
-
Cell linking effecting Last Modified date for whole sheet
I have a Main sheet with a cell that is linked to a log sheet to count total rows. whenever a form user adds a row to my log sheet it is updating the last modified date for all the rows on my main sheet. any idea how I can have this stop happening so I can send out a notification for any row that has not been updated in…
