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?
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.