Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
IF AND SUM?
jb@59069
✭✭✭✭✭✭
Hello, I need some help here, please.
I need to check the value of a text column and a checkbox column, then SUM another column based on the results.
Here's what I think it should be but am getting "#UNPARSEABLE":
=IF(AND([Project/Event]:[Project/Event], ="C2 NRM", [Billable?]:[Billable?], =0), SUM[Time Worked]:[Time Worked])
I have also tried:
=IF(AND(SUM[Time Worked]:[Time Worked]), [Project/Events]:[Project/Events], ="C2 NRM", [Billable?]:[Billable?], =0)
Obviously I'm missing something.
Thank you.
Comments
-
I think you'll want to try SUMIFS function.
=SUMIFS([Time Worked]:[Time Worked], [Project/Events]:[Project/Events], "C2 NRM", [Billable?]:[Billable?], 1)
Good Luck
Shawn
-
This content has been removed.
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives