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.

Formula DATE & IF

edited 12/09/19 in Archived 2017 Posts
11/30/17 Edited 12/09/19

Hi,

I have a sheet that I use for accounts. I have a column for Invoice Date, a column for Due Date and a column for Status.

I would like a formula for the status column to read "due in X days" ( a countdown of sorts) if invoice and due date same, read "Today" and once the due date is in the past, I would like the status to change to "Overdue". 

I can calculate the number of days with a simple formula =([DueDate] -[Invoice Date]) but apart from giving me a number, I can't seem to get the correct, IF formula to suit my preferred view.

I seem to struggle with combining formulas. I'd appreciate some assistance with this.

Cheers,

Kathy

 

 

Tags:

Comments

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    I think you are missing a comma in your question.

    Does an Invoice Date entry signify the completion of the task?

    Invoice Date empty:

    Due Date in the past = "Overdue"

    Due Date today = "Today"

    Due Date in the future = "due in X Days" (where X is variable)

    Invoice Date not empty: 

    ?

    But this does not match your attempted formula of =([DueDate] -[Invoice Date])

    So I am not sure what the exact spec is.

    Craig

     

     

This discussion has been closed.