-
Non-Task Related Project Description/Information/Demographics
Is there a way to add Non-Task Related Project Description/Information/Demographics to a project without using rows? I feel like we need a demographics page that we can add non task data.
-
Dashboard and Printing as PDF
Hello - Hoping someone can help. I've created a dashboard that looks fine on the screen and when published via a URL. The problem I'm having is when I print to a PDF the fonts are very small. The document is almost unreadable. Is there anyway to change it so the text look bigger. Just a couple things to mention: 1. The…
-
Macro or VBA funtions
I'd like to be able to create a macro or VBA code that would allow me to create a job folder on our local server using data from my smartsheet. The VBA code in Access looks like this: Private Sub cmdCreateCaseFolder_Click() If Dir("\\MA021SFS01\NorthEast_EWP\2018CaseFolders\" & Me.Project# & "-" & Me.Project Name & "-" &…
-
Where can I put completed, abandoned, or inactive Workspaces?
We have completed projects, or abandoned projects, with Workspaces. We don't want to lose them, or archive them to Excel - especially since the abandoned projects could come back to life one day. The problem is we have so many workspaces, the inactive workspaces are junking up the folder list. Is there anyway to create a…
-
Highlight If Older Than 'X' Days
I'd like to use conditional formatting to highlight a row or cell if it's older than 30 days. It's helpful for us to see which tasks are stale. However, there's only an option for "In the last 'x' days" or "older than (a date)". Has anyone found a good workaround or submitted this as a feature request?
-
PLEASE tell me what is wrong with this formula
=IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today8, "Red", IF([Due Date]8 = Today8, "Yellow", IF([Due Date]8 > Today8, "Green")))) Very new at this, but I can't see the problem...
-
Complex Formula for RYG Automation
I automated the RYG circles according to several columns of a Smartsheet grid for project management purposes. The logic is below: IF [Proposed Product Launch Date] <TODAY, "Gray" IF [Proposed Product Launch Date] >=TODAY AND [Deviation from Proposed Launch Date] <100, "Green" IF [Proposed Product Launch Date]…
-
Exporting to Excel - "We have found a problem with some content"
Hello, I have a Smartsheet that is less that 2000 lines. About a month ago, this error comes up when I export File to Excel format. Please see attached screen prints and advise. Thank you, Eileen
-
Month Function
Hello, I am trying to figure out how to extract months out of a grid. My goal is to count how many assignments were completed within each month of the year. e.g. | January | 45 | --------------------- | February| 20 | However, I am finding trouble actually calculating the amount based off of the creation date. I figured a…
-
Removing Parent Rows from a report
Hello everyone, I am using Smartsheet to manage several projects, all on individual sheets, with a high level role up for managers. We are trying to create a report that goes through all of the projects in a certain workspace and looks for tasks that are past their due date, then outputs the project name, task and who it…
