I have the following formula that works and I would like to add one more criteria, if Bid? = "Bid" then return 100% in %Complete Column
This is the original working formula:
=IF([Include in Estimate]@row = 0, 1, IF(OR(NOT(ISBLANK(Units@row)), NOT(ISBLANK([Fixed Cost]@row))), 0.25, 0))
This is my edit which returns the Incorrect Argument Set
=IF([Include in Estimate]@row = 0, 1, IF(OR(NOT(ISBLANK(Units@row)), NOT(ISBLANK([Fixed Cost]@row))), 0.25, 0), IF([Bid?]@row = "bid", 1))