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?

Options
jb@59069
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

  • SmSulli
    Options

    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 discussion has been closed.