-
Adjusting Threat Level Formula
I have a formula to set the threat level based on my status and milestone date. =IF(AND([Percent complete]@row <> 0.3, TODAY() > [Current milestone date]@row), "Red", IF(AND([Percent complete]@row < 0.3, TODAY() <= ([Current milestone date]@row + 30)), "Yellow", "Green")) I want my status to be green when the course status…
-
Combining (if and) with an IFERROR
I am trying to combine two statements. The original IFERROR statement works fine. I want to evaluate my duration column (milestones) and if duration is 0, then I want to simply evaluate baseline date - start date and put a specific value in the cell. =IF(AND(Duration@row = 0, [Schedule Delta (Working Days)]@row = >1)),…
-
What formula should I use to create a basic health assessment?
I am trying to create a health risk assessment for this particular template in Smartsheet. For some reason I am getting the unparseable error code. I want my team to be able to look at this form and see colors that represent where we are at and what is at risk for being "overdue" based on the end date. Green is good,…
-
looking for an efficient way to calculate the number of weeks
Is there a more efficient way to calculate the number of weeks between a start date and an end date without using intermediary steps or an extra column? Currently, I use a formula to find the difference in days between the two dates and then divide by 7 to get the number of weeks. I'm wondering if there's a more direct…
-
How can I copy parts of one sheet to another
Good morning! I am hoping someone can please assist me. I have two sheet. Sheet A is a Master Staffing Roster PM's maintain. They use this everyday. There are times when information from the Master Sheet needs to be inputted into Sheet B. Rather than the PM's typing it out I would like to automate it so only specific cells…
-
Networkdays formula syntax error
I used the AI formula builder to create a formula to calculate the number weeks (weeks out) between a launch date and milestone dates. I want the weeks out to always be positive. When I try to convert the provided formula, which works in the cell I place it in, I get a syntax error. I can't figure out the error.
-
indicate yes/no if date is between dates
I'm trying to incorporate a simple indicator on whether or not a task was completed within the appropriate timeframe. the timeframe is +/- 30 days from the date due column date. I've tried a number of formulas and none of them seem to be working and I can't figure out why. Is it because the earliest/latest dates possible…
-
Math Logic Formula - IF THEN ELSE?
Hoping someone can help with what I think is an IF, THEN, ELSE logic math calculation. I created an IF, THEN formula but now need to step it up. Need to create a formula that will calculate an amount due based upon a previous formula but there is a minimum and maximum ceiling to the amount that can be due. We enter an…
-
IFERROR, INDEX, MATCH, IF(AND( Formula for 5 sheets?
So, this is a doozy. I am trying to create one report that, when one piece of information is entered, pulls the rest of the necessary information from across five other sheets. I have seen a discussion on this forum about doing just that thing, but the difference is, I need to include certain criteria within the search,…
-
Enabling date columns to be incorporated into formulas
I have built a milestone report. To keep it current, I am asking my team to update 7 columns (for 7 milestones) every week in the weekly updates sheet, so I can track. In my sheet summary I am then pulling the most current values from the weekly update sheet. It is an Index Match formula, but it only can pull the date when…
