COUNTIF statement  if there is a number greater than zero then it counts as one
I think I need to use a countif statement but I am unsure how to incorporate this formula. If there is a number in one of those cells greater than zero under the 'Service Type', 'Project ID', 'Project End Date', 'Reason for Termination' or 'Resource posted time?' columns then for that person in the PRM column it should count it as 1.
I have tried and IF OR and COUNTIF
1st Formula resulted in #UNPARSEABLE
=IF(OR(Category8 = <>"",[Service Type]@row = "",[Project ID]@row = "",[Project End Date]@row = "",[Reason for Termination]@row = "", [Resource posted time?]@row = "", ), 1)
2nd Formula resulted in #INVALID OPERATION
=COUNTIFS(Category9:Category9, CONTAINS(">0", [Service Type]@row, [Project ID]@row, [Project End Date]@row, [Reason for Termination]@row, [Resource posted time?]@row))
Adriane
Best Answer

This formula worked: =IF(SUM([Service Type]@row:[Resource posted time?]@row) > 0, 1, 0)
Adriane
Answers

This formula worked: =IF(SUM([Service Type]@row:[Resource posted time?]@row) > 0, 1, 0)
Adriane
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!