Entry date/Payments

WWP

I have a sheet that tracks payments made by certain clients. When I add a new client that payment is due in June, the formulas are putting in automatically, payments that "should" have been paid in May. How do I make it so that the sheet won't calculate until the "entry date"?

Andrée Starå

Hi @WWP

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

WWP

ss.pdf

Here is a screenshot and explanation! Thank you!

Genevieve P.

Hi @WWP

Data showing up in your previous columns will be based on the formulas that are in those cells. You could likely add an IF statement at the front that essentially says that IF the date in the Entry Date column is greater than X month, then ignore it, otherwise, carry on with your current formula.

=IF([Entry Date]@row > DATE(2024, 01, 01), "", formula

You'll need to change out the DATE you're looking for in each of your month columns. Does that make sense?

Cheers,

Genevieve