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
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!