Logic Project Plan

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

Find more posts tagged with

Formulas

Reports

functionality

Project Management

Accepted answers

All comments

Bassam Khalil

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 Khalil

@Finops C'ship

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.

Finops C'ship

Hi @Bassam Khalil

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.