checkbox used to trigger an action.

Hammerink_PK1

I am working on a budget sheet that I am using to estimate costs for construction projects. I obtain two bids for each trade or task. I have Column 3 named "SUB 1". Column 4 is named "bid 1" which is the price the subcontractor bid the work for. column 5 is a checkbox. Column 6 is named "sub 2". Column 7 is named "Bid 2" which, as above, is the price the subcontractor bid for the work. Column 8 is another checkbox. Column 9 is named "sub total".

I would like to use the checkbox feature as a trigger to make the lower price bid appear in Column 9 "sub total". In other works, if Sub 1 bid $10,000 and Sub 2 bid $12,000, I would click the checkbox nex to sub 1 and the $10,000 amount would appear in the subtotal column.

Is this possible?

Paul Newcome

You would use a nested IF statement for this. Something along the lines of...

=IF([1st Checkbox]@row = 1, [1st $$ Column]@row, IF([2nd Checkbox]@row = 1, [2nd $$ Column]@row))

Stacey Carrasco

@Paul Newcome I'm stumped again 🤨 this time with what should be easy formula that I can't see what's missing and need another set of eyes 🤦‍♀️

=IF([Due Date]@row <= TODAY(), AND(Status@row = "Not Started", Status@row = "In Progress", Status@row = "Completed", 1, 0))

I just want the row to check if the due date is in the past and if the status is not started or in progress. If complete no checkbox is required.

So where did I goof this one up 😁

Thank you

Paul Newcome

@Stacey Carrasco Write your formula the same way you write your logic.

due date is in the past and if the status is not started or in progress

(due date is in the past AND if the (status is not started OR in progress))

=IF(AND([Due Date]@row<= TODAY(), OR(Status@row = "In Progress", Status@row = "Not Started")), 1)

What other statuses do you have besides those three?

Stacey Carrasco

@Paul Newcome

That was it!!! ugh!! Ahh as you can see I get stuck on the little things some times. 🤦‍♀️

I only have 3 status options.

Thanks agian

Paul Newcome

@Stacey Carrasco In that case you can save yourself a little bit of typing and just say is less than or equal to today and status is not equal to completed.

=IF(AND([Due Date]@row<= TODAY(), Status@row <> "Complete"), 1)

Cuts out a reference as well as a function (and the associated parenthesis).