-
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.…
-
Trying to Clear a "Ball in Court" cell when item is complete
Help! We are trying to set up a formula to clear the "Ball In Court" when a line is complete. I know that you cannot format a formula in a contact cell, but there has to be a way! It's appearing as though work is still needing done and it is not plausible to remember to clear the cell each time something is complete. Any…
-
Returning Data with a formula
Boy have I gone round and round with this! This formula is meant to bring back the data from another sheet based on the code entered (ie: code - CALVE and it should return the full name, email of that company from a different sheet). Sometimes this formula works perfect and other times it brings back the wrong company? Can…
-
Inconsistency with FS Predecessors
This might be incredibly simple but I can't seem to find it already answered! Sometimes when I set a Finish to Start predecessor, the auto-filled "Start Date" is the same date as the predecessor row instead of the following business day. This seems to happen only about half the time. I've attached an example of me having…
-
How do I return a value, based on a date, between dates? (versus week numbers)?
I am trying to return a value to a cell, based on a date condition at the top of the column. For example, if there were 52 columns of the "week dates" in a year. The parameter for the return value is IF the date condition falls between a start date and finish date. I have been able to do this when I convert all dates to a…
-
IFERROR
HI all, I have a sheet where I am collecting data. One is our overall variance. In certain rows I do not have data and receive the #DIVIDE BY ZERO message. I have attached the screenshot to show my formula. Thank you,
-
Cross sheet formula - Reporting by week
Hi Again! Is it possible to create data that provides QTY of selections checked per week and record this on a sheet automatically with formula. So we are managing live installation projects, with a high turnover of projects. Our main sheet is called PROJECT MILESTONES where we track all the live project activity. Within…
