Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Smartsheet Budget Formulas

Divya Purnima
edited 12/09/19 in Archived 2017 Posts



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.


  • 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?



This discussion has been closed.