Auto Date Calculation
Very new to SmartSheet, I am trying to create a Purchase Tracking sheet that can be used for Payment Schedule.
Here is what I have " Invoice Date" This I put it manually whenever I receive an invoice from my vendor.
I also have another cell "Droplist" which state payment terms like 30/60/90 days.
What i need is
1) A Separate cell inputed as a column, which will use the Invoice date Add the Term Date and Give me a Payment Date
2) I have a column which auto-populate the current date. hence I need a separate column when today's date crosses the payment date, It auto fills the overdue date and the entire row goes RED.
Please tell me if this is possible and if so how can it be achieved.
Thanks in Advance
Help Article Resources
Check out the Formula Handbook template!