Forum Discussion
Solved
Sharepoint List Calculated Column showing bad results
Hello! Forgive all the background. I have used forms for our sales team to enter details of items that have been rented as part of the deals they close. Not all deals include all products on the ...
This formula works, you'll have to update the to use the correct field names. IF statements are pretty easy once you do them a few times.
=IF (condition, condition is true, condition is false)
So if a date field is empty, use your formula between them commas, other leave it blank.
=IF([End]>0,DATE(YEAR([End]),MONTH([End])-([Renewal]),DAY([Start])),"")
This formula works, you'll have to update the to use the correct field names. IF statements are pretty easy once you do them a few times.
=IF (condition, condition is true, condition is false)
So if a date field is empty, use your formula between them commas, other leave it blank.
=IF([End]>0,DATE(YEAR([End]),MONTH([End])-([Renewal]),DAY([Start])),"")
- Thank you PamDeGraffenreid this is great! and worked like a charm!
