Logic Project Plan

Options

Hi ,

Need a help on the project plan logic related to Sch Health.

The logic i am using on the schedule Health is not showing me the correct result.

As you can see Start date is 06/01 and End Date is 06/30 the % Complete is 50% ideally it should be green because it just a week and the % complete is 50%

Can any one help on the formula ..I am new so I have not much Idea how can I make this formula as per the above infomation.

=IF(Status@row = "In Progress", "Red", IF(Status@row = "Complete", "Green", IF(Status@row = "Not Started", "Gray", IF(Status@row = "On Hold", "Yellow", ""))))

Thanks

• ✭✭✭✭✭✭
edited 06/09/21
Options

Hi @Finops C'ship

Hope you are fine, did you mean if the status in Progress & the end date < today you want the schedule Health to be green.

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

could you please define all the conditions you want for the schedule Health and define the indicators you want to see so i can write the formula for you.

bassam.khalil2009@gmail.com

• Options

For instance-

Start Date is 20/05/2021 and End Date is 22/05/2021 and say today date is 21/05/2021... the Target Completion is 66% ----- We want a formula on Smartsheet that will first calculate the target completion in a column and Actual % complete this will be manually inputted by the team.

Now you can see i am using a formula on excel I want this to be on the smartsheet so, that it compare the Actual with the target completion based on Today date and mark the Schedule health accordingly.

so if Actual is greater than equal to Target it should be Green else red.

Can you help on this..THanks

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!