IF(AND) statement in Sheet Summary Field
Hello, I have searched and gotten close but no cigar yet!
I'm trying to create and IF,AND statement in a Sheet Summary field, (defined as Data Type: Text/Number).
I want one of two outputs in the Sheet Summary Field:
- "Active" when a specific task name has Status <> Complete
- "Complete" when the same specific task has Status = Complete.
My formula is: =IF(AND([Task Name]:[Task Name], "Go Live Successful", Status:Status, "Complete"), "Complete", "Active")
I'm getting the error: #INVALID DATA TYPE
The specific task I'm targeting is Go Live Successful:
I am putting this in the Sheet Summary so I can create a metric widget to count the number of active and completed projects in the dashboard.
Any advice or direction you can provide is greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!