Struggling with an IF/OR/AND formula

Lydia Bowman

Hi,

I have a formula I'm struggling to put into a single IF/OR/AND formula!

Basically, if the [Add-ons] column includes the tag "Prebill" AND if the [Final Invoicing] column is “Invoiced”, I want the [Total Amount Invoiced] column to add [Prebill Actual Invoiced] and [Final Invoicing Amount]. To clarify, if just one of these true, I'd still want the [Total Amount Invoiced] to populate with the amount of the true value. But if both are true, then they'd need to be summed.

Otherwise (that is, if the row isn’t tagged as “Prebill,”), I need the [Total Amount Invoiced] to follow this formula (which works on its own, but maybe there’s a neater way to even do this piece!):

SUMIF([First Draft Invoicing]@row, "Invoiced", [FD Actual Invoiced]@row) + SUMIF([Final Invoicing]@row, "Invoiced", [Final Invoicing Amount]@row)

Thanks for your help!

Gillian C

Hi @Lydia Bowman

Is it the case that you are always going to have First Draft Invoicing?…so if Add-ons = Prebill will you also First Draft Invoicing = Invoiced.

Lydia Bowman

Hi @Gillian C, yes, that's correct in this instance!

Gillian C

@Lydia Bowman

Apologies! I totally forgot about this (out of the office for a few days!) Did you get a solution?