0

I need a little bit of help with calculated fields in SharePoint. I have 4 dates (it can be more in the future). All 4 dates are due dates. So lets say I have 4 fields.

[Car Damage repair]
[Car cleaning]
[Car Polishing]
[Car Maintenance]

Now I want a calculated field [Planning first date] which gives me the closest date from now.

1

Yes, you could create 3 Calculated fields to realize your design.

Please follow steps:

1.Create the first Calculated field named "C1"

Formula:

=IF(INT([Car Damage repair])>INT([Car cleaning]),[Car Damage repair],[Car cleaning])
//compare the values of the first two fields

enter image description here

2.Create the second Calculated field named "C2"

Formula:

=IF(INT([Car Polishing])>INT([Car Maintenance]),[Car Polishing],[Car Maintenance])
//compare the values of the last two fields

enter image description here

3.Create the last Calculated field named "Closest date"

Formula:

=IF(INT(C1)>INT(C2),C1,C2)
//compare the values of [C1] and  [C2]

enter image description here

4.Go to List page, click the column field [C1] and select Column settings >> Hide this column. [C2] is the same operation.

enter image description here

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.