You are viewing limited content. For full access, please sign in.

Question

Question

Can I prevent a value from being used in field based formula based on another value in the same row?

Forms

Updated April 16

asked on April 16

I have a Total Hours worked field with a formula that gets the SUM of Labor Hours in in a table.

=SUM(Labor_Entries_for_Today_1.Labor_Hours_9,ROW())

What I would like to do is add the option to exclude the Labors Hours value from that row if the value of D is 1 on the same row.

In the image below, I would like to have the Total Hours Worked be 0.50 and NOT 2.00.

0 0

Answer

SELECTED ANSWER

replied on April 16 • Show version history

You should be able to achieve this by changing your formula to a SUMIF:

=SUMIF(Labor_Entries_for_Today_1.ValueOfD, "<>1", Labor_Entries_for_Today_1.Labor_Hours_9)

(Just change the ValueOfD to reflect your variable name for that column and you should be good to go.)

Let me know if you have any issues and I can try to help troubleshoot.

0 0

Replies

replied on April 16

Thank you once again. That was it. :)

1 0

replied on April 16

Perfect! Happy to help. :)

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked April 16
Updated April 16
35 views