Smartsheet Budget Formulas

Hi,

I would like to know the formula for the due date of every month to calculate the receivables and Payables.

For example, I have the data with amounts and due date of the payment. How can I input the formula, grab the amounts by the due date of every month. Please let me know.

Find more posts tagged with

Formulas

Reports

Support

Comments

Kara Lumley

Hi Divya,

If your due dates change throughout each month, you can use this formula to see the sum total of what is due in the current week.

=SUMIF([Due Date]:[Due Date], IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()), Amount:Amount)

Or, were you asking for a calculation to create the due date?

Best,

Kara