Share
Report
9I have a SharePoint list that is used to track which items are being rented along with the separate columns for the start_date and the end_date and a column for the salesperson to set the number of months in advance of the end date they need to begin getting the renewal started (renewal_start) all of these are originally added through a "Form" which uses branching to eliminate unnecessary inputs for example.
Item # 1 Y/N
If Yes go to start date, end date, renewal offset, and on to Item #2
If No go to Item #2
Item # 2 Y/N
If Yes go to start date, End date, renewal offset and on to Item #3
If No go to Item #3
and so on... Which means that if item 2 was not rented then there is no start date or end date or renewal offset.
I have a flow that moves the the information into a SharePoint list along with a column listing the number of months before the contract renews (renew_kickoff). I have added a calculated column that looks at the End_Date column, subtracts the number listed in renew_start column and shows the outcome as date. I plan to use this to notify the sales person they should begin working on getting a renewal. The calculation is working except for one small oddity when an item is not chosen on the form, no start_date or end_date is chosen (because they did not buy that product. So there is no end_date on the list nor is there renew_kickoff date on the list.
On the lines where there is no data the Calculated field is displaying the date 12/30/3799 which brings me to my question. How Do I ensure that no date is displayed in the calculated field if its other fields are blank? Is this something that I need to address in my Flow or the SharePoint list? Any thoughts would be great. T
his is what it look like in SharePoint:
All responses (
Answers (
