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
Divya Purnima ✭✭
edited 12/09/19 in Archived 2017 Posts

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.

Tags:
· Share on FacebookShare on Twitter

Comments

  • Kara Lumley
    Kara Lumley Employee

    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

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories