Aug 15 2022 09:52 AM
Does anyone know what formula I should be using?!
I want a formula that can look at the status of all the invoices (2nd picture), and if they all say 'Paid,' then take the month of the most recent input and put it into the date of final invoice cell (1st picture). (The status of the invoices can be "Prepared," "Sent," or "Paid")
Aug 16 2022 09:02 AM
SolutionHi @YoloSpaceMuffin,
I hope I have interpreted your wish correctly. I'm afraid you haven't told us everything. Have a look at the enclosed example. I have created an IF() query that checks whether everything has been paid and, if so, gives you the maximum value for the date.
Does this come close to what you have in mind?
Aug 17 2022 01:43 PM
Aug 16 2022 09:02 AM
SolutionHi @YoloSpaceMuffin,
I hope I have interpreted your wish correctly. I'm afraid you haven't told us everything. Have a look at the enclosed example. I have created an IF() query that checks whether everything has been paid and, if so, gives you the maximum value for the date.
Does this come close to what you have in mind?