I have a project I am working from. I am essentially building a queue of sorts using lists, that will show things like “account number”, “client name”, “contact person”, “due date”, and “completed date”. I get emails in outlook with a file attached, and for now I am just copying and pasting all of that info, attachment included into share point via “+New Item” from the list page. I have columns for “date received” (when I got the email/file), “in process” (when I actually start filling the form out), “due date”, and “completed date”.
Due date uses a calculation on =[in process]+14 this is because we tell our clients to expect up to 14 days for us to complete their form. The other 3 columns are “date and time” columns. One thing I have noticed is that until I enter in a date for “in process”, the due date shows up with “1/13/1900”. Is there a way that the due date can stay blank until I put a date into “in process”?
Thank you for any help on this. It’s much appreciated.
You can specify an if statement, checks if in process is blank, set it to empty. Otherwise calculate.
=IF(ISBLANK([in process]),"",[in process]+ 14)
