Date Calculations for SharePoint List Columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1615937%22%20slang%3D%22en-US%22%3EDate%20Calculations%20for%20SharePoint%20List%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1615937%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20want%20to%20create%20some%20calculated%20columns%20in%20my%20SharePoint%20List.%20The%20conditions%20are%20as%20follows%3A%3CBR%20%2F%3E%3CBR%20%2F%3E1)%20Start%20Date%20Column%20%3A%20Documents%20Today's%20Date%20whenever%20a%20new%20item%20is%20created%20%2F%20added%20to%20SharePoint%20List.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E2)%208D%20ETD%20Date%20Column%3A%20Start%20Date%20%2B%2024%20Working%20Days%20(Mon-Fri).%3CBR%20%2F%3E%3CBR%20%2F%3E3)%20XYZ%20Date%20Column%3A%20DOcuments%20Today's%20Date%20whenever%20the%20STatus%20of%20the%20List%20Changes%20From%20Status%20%22A%22%20to%20Status%20%22B%22.%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20do%20i%20achieve%20these%20things%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1615937%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1616584%22%20slang%3D%22de-DE%22%3ESubject%3A%20Date%20Calculations%20for%20SharePoint%20List%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1616584%22%20slang%3D%22de-DE%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F773149%22%20target%3D%22_blank%22%3E%40akash_saraswat%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3Eyou%20can%20do%20this%20better%20with%20power%20automate%2C%20then%20with%20calculated%20fields.%20Those%20are%20only%20a%20calculated%20view%20and%20consist%20of%20not%20real%20data.%20To%20consistantly%20manipulate%20your%20SharePoint%20Fields%2C%20just%20set%202%20normal%20additional%20text%20fields%20within%20your%20list%20or%20library.%20These%20text%20fields%20you%20can%20calculate%20in%20an%20automatic%20flow%2C%20e.g.%20when%20an%20item%20is%20created%20or%20modified.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20dates-data%20then%20will%20be%20transformed%20into%20text%2C%20with%20the%20json%20code%2C%20back%20to%20your%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESpecially%20when%20your%20second%20calculated%20field%20has%20to%20have%20a%20condition%2C%20I%20recommend%20strongly%20to%20do%20that%20in%20power%20automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20don't%20where%20to%20start%20to%20learn%20it%20with%20date%20calculations%2C%20pls.%20explore%20the%20youtube%20videos%20from%20Audrie%20Gordon%20and%20her%20Friday's%20Functions%20Series.%20I%20learned%20a%20lot%20from%20her%20and%20can%20remember%20one%20of%20her%20videos%20dealing%20with%20date%20functions...%20Hope%20that%20helps%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello everyone,

I want to create some calculated columns in my SharePoint List. The conditions are as follows:

1) Start Date Column : Documents Today's Date whenever a new item is created / added to SharePoint List. 

2) 8D ETD Date Column: Start Date + 24 Working Days (Mon-Fri).

3) XYZ Date Column: DOcuments Today's Date whenever the STatus of the List Changes From Status "A" to Status "B".

How do i achieve these things

1 Reply
Highlighted

Hi @akash_saraswat ,

you can do this better with power automate, then with calculated fields. Those are only a calculated view and consist of not real data. To consistantly manipulate your SharePoint Fields, just set 2 normal additional text fields within your list or library. These text fields you can calculate in an automatic flow, e.g. when an item is created or modified.

 

The dates-data then will be transformed into text, with the json code, back to your list.

 

Specially when your second calculated field has to have a condition, I recommend strongly to do that in power automate.

 

If you don´t where to start to learn it with date calculations, pls. explore the youtube videos from Audrie Gordon and her Friday's Functions Series. I learned a lot from her and can remember one of her videos dealing with date functions... Hope that helps, Eva.