Best Of
Re: How to change task bars of parent rows in the Gantt chart?
@Andrée Starå Ok, thanks! You know what's odd? The formatting will show up in reports. Check it out. This is sourced from the same Project Sheet I shared above.
Khasse
Formula not working
Hello, I am trying to make a formula that will automate a symbol based on a text in another column. Below is my current formula that isn't working. Any help would be appreciated!
Designations I would like are: Complete = Green; Planned = Blue; In Progress = Yellow; ON HOLD or N/A = Red
=IF(ISBLANK([RegSci Review Status]@row), " ", IF([RegSci Review Status]@row = Complete, "Green", IF([RegSci Review Status]@row = Planned, "Blue", IF([RegSci Review Status]@row = ON HOLD OR N/A, "Red", IF([RegSci Review Status]@row = In Progress, "Yellow")))))
RobynK
Re: Meet and Eat sessions - Chat with your peers over lunch!
I saw this post, and was bummed that it was only for Engage. I so wanted to go, but since I am a Contractor, my company won't send me, and I cannot afford to absorb the cost on my own. Maybe next year! And thanks for thinking about all of us that want to attend Engage, but simply can't. A Virtual version, or even recorded version would be fun.
Sherry Fox
Re: Meet and Eat sessions - Chat with your peers over lunch!
This title got me so excited until I realized there's no virtual option 😥 I hope we get to hear about the awesome conversation and takeaways!
Amber Eakin
Re: INVALID DATA TYPE Error in single cell of column formula
Only thing that sticks out is the YEAR() function.
Check {Site Visits Range 2} sheet and add a column there with the year function and see if anything is giving you an error.
This could mean it does not have a proper date in the cell.
You could also add an IFERROR() in your formula to ignore them: IFERROR(YEAR(@cell),0) = 2023
Leibel S
Re: tracking # of employees quarter over quarter
You will want to start your formula with an IF.
=IF(TODAY()>= [Quarter Start Date]@row, COUNTIFS(..........), 0)
Paul Newcome
Re: Join the conversation + Help us use sponsorships as a force for good
Creativity is the catalyst that ignites our potential, allowing us to break free from norms and shape a unique and extraordinary world. Embrace it, for within its realm lies the power to unleash your true brilliance and leave an indelible mark upon the tapestry of life.
Itai Perez
Re: Can a person not shared to a sheet participate in proofing activities?
Can you describe how you're sharing the Proof?
The "Invite" button should only invite reviewers to the external proof page, and not to the sheet (unless they also have access to the sheet).
See: Request review and approval
Let me know if this helped!
Cheers,
Genevieve
Genevieve P.
Re: Calculating the "Average" RAG Status
Hi @Safiya B,
If you've grouped things up with indentation then you can do this.
Here the formula in the project status is:
=IFERROR(IF(COUNTIF(CHILDREN(Status@row), "Red") / COUNT(CHILDREN(Status@row)) >= 0.2, "Red", IF(COUNTIF(CHILDREN(Status@row), "Yellow") / COUNT(CHILDREN(Status@row)) >= 0.2, "Yellow", "Green")), "")
I've put it in a seperate column in order to have it as a column formula, but if you only have a few lines you could equally have it in the lines for project with some copy/pasting.
Hope this is of some assistance - if you've any questions etc. then let me know!
Nick Korna
Re: Combining If and AND statements
It is basically just stringing the cell data together.
The only part that wasn't just "adding" the cells together (with spaces in between) is the middle portion where we used the LEFT function to pull the leftmost word out of the cell for the size, and we used the FIND function to tell it how many characters to pull from the LEFT going up to the first space.
Paul Newcome