Please help! I have a project plan and am looking to use formulas to automate the status column for each task based on if the due date has passed and completion % is below 100%. How best can I do this?

like
Posting as :
works at
You are currently posting as works at

It sounds like you can probably use IF statements for IF date > due date and IF the relevant cell in completion column is <100. If you have various statuses like not started, in progress, you may need to further clarify the parameters

Hope it helped a bit

Conditional formatting works well to color code the status for tasks. Green for 100%, yellow for 75%, red for 25% as an example.

Related Posts

Hi! Anyone here working at Leo Burnett Toronto? Even better if you’re part of the client services, HR, talent acquisition team? 🙏

like
like

Haha it's a mix of product management, project management, product development, consulting work, technical stuff, analytical stuff. Literally anything the project needs to succeed haha

like

ISO an ACD of visual design for our Nike client! Fully remote, but willing to work on PST hours. Must have a book with projects that include typographic variation, motion samples, systematic brand visualization, digital UI design and design driven campaigns. Hit me up if this sounds like you!

like

I have an offer from virtusa for 17 lpa the project is of banking domain how is work life balance and tech stack?

like

Wooohoo just landed a data project! Woohoo data! Data runs the world! Hello super high utilization! Hello cushy bonus! 🙌🏽

like

Has anyone ghost-written before? I have a potential client looking to write a wellness journal and I am looking for tips on fee and any and everything else in regards to being a ghostwriter. Would love any guidance.

like

Interviewing with PVH for a project coordinator role. I think I may be overqualified (3 year consultant but wants to exit to Fashion). Would love to know what the interview process entails, some salary insights, and overall satisfaction. Thanks!

Hi Team, I have joined GlobalLogic last week only and have been asked to join one client from cyber security domain but after joining got to know that client is chaning few things is team and because of that only they are also not sure if I will be assigned to that project or not. ( discussion still in progress with client )
What should I do ? Do they have enough project to accomodate me in different project ?
I also have offer from cognizant.
YOE - 8.7

like

What's the best way to get your project changed in IBM?
Working in energy utilities account for last 10 months as a BA, but the work is not good at all.
Should I try to check with my people manager or look outside IBM ?

like

How are the client and project interviews for SAP in Capgemini? Are those tough?

like

Hi fishes,
Need your thoughts.
I am done with my client interview and it went well but they are asking me to come to gugaon location.
I am from Bangalore location.
I directly said to client that I can't since I have my family here.
When I inform this to my manager he is saying how come u say like this to client.according to kpmg policy u need to travel to anywhere to work.
This is not good right. What should be my reply to the client in such a case and how to handle manager on this?

like

How is HSBC Client in terms of WLB and work culture

like

Larsen & Toubro Infotech I’m selected as a blockchain developer in LTI Hyderabad. HR is not disclosing the Project name. Are there good projects in Hyd location for blockchain? Please help me.
Thanks in advance.

Larsen & Toubro Infotech.

like

I’m Looking for a flexible 100% globally Remote opportunity in either of these:

Project Management
Scrum Master
Delivery Manager
Digital Manager

Any help would be greatly appreciated🙏
Please like to push the app to share.

likesmarthelpful

Is it common for a copywriter to transition into account/project management within digital marketing?

like

I have an upcoming interview for a principal project manager position with my company. How can I ensure I get a huge raise?

like

Is there a market for lawyers to add expertise In crisis management or reputation management? My goal is to counsel clients on how to respond to media inquiries without saying or posting something detrimental to a potential litigation while still maintaining communication with their client base. If so, how to break into that industry? Courses? Books? Certifications?

like

Last week joined in hcl. I got better opportunity in other company.If I abscand in hcl.does it any problem?still I have not assigned to any project , iam in Bench now?

More Posts

I have no issues dating/sleeping with my neighbors, co-workers (sometimes, happened twice), and hired help (personal trainers, massage therapists, mechanics). My excuse: I'm a busy gal who doesn't have time to screen men on apps. I have an insatiable appetite for sex and the convenience doesn't hurt!

likeupliftingsmartfunny

What is the salary I should ask for in IBM.. YOE: 6.5, SAP FICO… Current Salary 15 LPA

like

Been questioning my friendship with a group of girls. Really close to them before (been hanging out since high school), but all they do is gossip, shop, and talk about superficial things, and I just started realizing how our interests are different too in the recent years. When is it time to drop the friendship if you feel like the odd one out?

like

Any tips for organizing a bedroom, closet, dresser & bathroom? My teen has IADHD, and low executive functioning. Her room looks like a land mine. Clean clothes are mixed in with dirty, her desk is a disaster, she won’t let go of clothes she’s outgrown, drawers are open with clothes hanging out. A therapist said to close her door if we don’t want to see it but it’s more than that. She needs this important life skill & I don’t know how to help. Easier to organize w/o her but that’s not a solution.

like

Tricentis is hiring for various roles. Please feel free to reach out if you are interested or know anyone who might be interested.

Post Photo
like

I (Spring Boot + Angular, FS, 6 YOE) interview candidates at the product company I work for.

People just show up with no prep. I interview for 4-6 YOE and these people aren't even expecting to write a single line of code. Even questions like "find the lesser of the two angles between the two hands of a clock, given the time" or simple geometry problems that don't need DSA knowledge is too hard to attempt.

They claim they know Angular/React/Spring without knowing basic Javascript/Java. 😒

like

Hi,
My HR discussion with
Cognizant is scheduled.
Is this going to be a salary discussion or questions like strength and weakness, why do you want to join etc?

EY -TAS , S&O . We are hiring. If interested, reach out...

likehelpfulfunny

Can someone explain 704(b) in simple terms?

like

Is there any sort of job that would allow an employee to fly all over the country on business for their company? Looking for roles that allow me to do that and travel! I’m mid-20s and few years work experience. Tired of the boring and slow as molasses work environment at the bank. TIA!

like

Tomorrow, Thursday September 5th from 6pm onward we're meeting at the Heineken Riverdeck at Pier 17. Come on out and enjoy the last few weeks of summer vibes.

Post Photo
like

Any insights on on-site opportunities in capgemini?

like
like

Is it normal for senior managers to ask you to cancel leaves or to nit apply leaves in EY GDS? My manager told in all hands meeting yesterday to not apply leaves during tear end. Won’t this become a hr issue?

like

Hey! Anyone interested in purchasing a SXSW Film badge at the early bird special cost of $895?

like

When renting out a property, can you specify which pets you'll allow vs not? Like no cats but small dogs are okay?

like

Did you buy all of the textbooks for nursing school or did you skip a bunch?

like

What skills do you need to be a creative technologist and where/how can you get them?

like

Hi Fishes,

Is S&P planning to open offices?

like

Hi fishes can some refer me for fraud investigation or compliance

Additional Posts in Excel Genius

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Presenting data in 2 tables that refer to the same pivot table as source. However, one requires a filter on the pivot table and when filter undone, values change back to original. How to tackle this?

like

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

Any book recommendations on excel modeling for real world business applications?

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Do you have to activate excel almost every time you use it- or is it just me?

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

My job often has me conducting analyses where we try to identify if product launch A has had an impact on B (cannibalization analyses) but super often they are inconclusive. I feel I need statistics / rudimentary data science here. Any idea what to study?

like

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

like

What are some of the unique use cases you have leveraged excel for?

like

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

likehelpful

Just got a dell and getting annoyed learning new shortcuts on excel (had HP prior) - how do I automatically get to cell A1? Used to be CTRL-HOME on HP and Lenovo

Post Photo
like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal