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
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.