-
Trying to create Cumulative Flow chart from task list
I am attempting to build a cumulative flow chart based on new, active, closed tasks. The struggle is coming from trying to build a sheet with formulas that will pull the information from the task list and hold onto the information moving forward. Once the formula finds the correct data it continues to update each cell with…
-
Conditional formatting of dates
I have two columns set up, one with a arrival date and one with a start date. I want to highlight the cells in the start date column if the proposed "start date" is before the "arrival date." The purpose if to show that the activity can't start before the materials have arrived. Does smartsheet have this ability?
-
Help using OR in SUMIFS
I cannot figure out how to change this formula so it will add up amounts in the Stage Column that has a dropdown with several options. Right now, the below works, but I want it to work when the Stage is Verbal Commitment OR Written Commitment. =SUMIFS([Committed $]9:[Committed $]64, [Current Campaign Name]9:[Current…
-
RYG Balls average
hello, i am looking to find a way to do an average with the RYG balls. ex: 2 green, 2 yellow, 2 red should have should show yellow ball for the overall project. is this something possible? thanks for your help
-
Counting Due This Week
I am trying to count anything that is due this week. I have a due date column in my smartsheet, but what is the best way to count this information?
-
VLOOKUP reference file not being captured through end of sheet
I am having an issue with VLOOKUP. I will attempt to explain. When I set up the parameters to "reference another sheet" I capture all of the row/columns through the end of the sheet. As I add new rows to the source/reference sheet and my main sheet the VLOOKUP does not return the expected values. When I look at the…
-
Change task Duration based on a condition in another cell
Hello Everyone. The projects I handle are the same each time in terms of the tasks to carry out. but they can differ in duration based on the 'size' of the work... I am using a standard sheet template which I also use to forecast, I would like to change the 'duration' of a set of tasks based on a dropdown that would return…
-
IF AND formulas
I wonder if anyone would be able to help me. I am trying to collate some data that allows me to give a count of a number of jobs that have missed a target date. The sheet I am working on also has 2 different cost centres and I would like to break this data down so that I can see the data for each cost centre. I have…
-
today plus x networkingdays
how do i build a formula that gives me the actual date for today + 35 working days?
-
Networkday
Hello all - first time poster I am trying to get the difference between two dates by using the NETWORKDAY formula and I am having an issue. I have 2 date field columns - an assignment date and a go-live date - and I am trying to find the difference in business days between the two. I have successfully run the formula to…
