-
Columns on Each Page of Schedule
This seems like the simplest task but I can't figure out how to have the columns in my schedule (Description, Duration, Start, Complete) show up on each page. It is easier for the Engineer to read that way without having to flip back to the first page to see what task he's following.
-
RYGG Automated
Hi all, I am unsuccessfully trying to create a formula for the following RYGG column: Column [Project at Risk] with the RYGG: * If [PROJECT START] (date) is more then a day over I want the [PROJECT@RISK] to display "RED" ball * If [PROJECT START] (date) is less then 7 days away I want the [PROJECT@RISK] to display "YELLOW"…
-
RYB Formula Help
I am having issues with developing a formula for an overall status. What I'm trying to do is based on multiple cell-status(RYB setup column) they will dictate what the overall status column of the project status is. Both columns have gray, red, yellow, and green balls. This is my current formula please help if you can.…
-
Count number of checked in a sheet
Hi Could tou please help me to count the nuber og checked rows in a sheets without making parent, children rows?
-
Pre-populate Web form with info from Dashboard
Hi everyone, here is what I'm trying to do: I want to create a dashboard with links to web forms when doing on-site audits. These links will be different sections of items being audited. When I encounter an issue, I would click on the link, fill out the form and then keep going with my walk-through. These forms would be…
-
Looking for a Guru to Build a Smartsheet + Quickbooks Solution
Hi I have a small engineering company 15 people that has not been able to find a real good Portfolio management solution so am considering creating my own with Quickbooks + Smartsheet. I use Smartsheet for managing commissioning projects so would expand this to include all of the 125 projects we currently have on the…
-
Rotting Alert
I use card view (Kanban) to track progress for the construction build process. I need to be alerted or have a rule to notify that a "card" has been sitting in a lane for xx amount of days. This would tell me that it has rotted and an action must happen. Any suggestions are appreciated.
-
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…
-
How can I display a date range based on week/month numbers?
Here's the situation: I have a bar chart on a dashboard that displays the dollar value of bids submitted by week going back the last five weeks and another for the last five months to help the estimating team track where we are on meeting goals. At the moment the labels under the bars are Last Week, 2 Weeks Ago, etc.…