if and formula not working
Hi,
looking for help on this formula
I would like for two conditions to be met for the total contract hours value to count towards the sum of the column.
so if the PIP type is equal to "CE PIP AC" and the status ball is green then the hours for that row should count in my sum.
I hope that makes sense.
=IF(AND([PIP TYPE]@row = "CE PIP AC"), [STATUS]@row = "GREEN"), =SUM(TOTAL CONTRACT HOURS:TOTAL CONTRACT HOURS)
Any help/guidance is appreciated. Thank you in advance.
Answers
-
Hello @LisaPetersonBW
Does this formula work for you?
=IF(AND([PIP TYPE]@row = "CE PIP AC"), [STATUS]@row = "GREEN"), SUM([TOTAL CONTRACT HOURS]:[TOTAL CONTRACT HOURS)]
This formula will populate "GREEN" if "CE PIP AC" is found, otherwise it will SUM the Total Contract Hours Column.
-
Hi Chris
Thank you for your reply, however, the formula is not working. it's not a green status ball it is a drop down Yes, No.
Sorry for the confusion.
Would I replace the "green" with "yes".
Also, I am hoping to have the cell to reflect the total contracts hours when the values in the status column are "Yes" and the "CE PIP AC".
I appreciate your help
Lisa
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!