Hi guys, I need some help with the formula to create a calculated columns in sharepoint

Question

Hi guys, I need some help with the formula to create a calculated columns in sharepoint.

Let say, we have Contract Execution Date (date and time) column and Potential TCV (Currency) column, i want to calculate amount in Spread form (Jan, Feb, Mar... Dec)

Example: Account A has Potential TCV is $1000 and Contract Execution Date is 02/27/2022, then $1000 should show me in Feb column (that i want to calculate), rest months should remain empty.

Similarly, if Account B has Potential TCV is $1500 and Contract Execution Date is 06/21/2022, then $1500 should show me in Feb column (that i want to calculate), rest months should remain empty.

Thanks

Answer 1

Hi @Sumitesh Kumar
You need to create 12 calculated columns for mons(Jan, Feb,,,Dec).

You could use below formula for Jan, data type choose currency:

=IF(MONTH([Contract Execution Date])=1,[Potential TCV],"0")  

Then create the rest 11 calculated columns, just replace "1" to "2" when create Feb, replace "1" to "3" when create March and so on.

As a result, you could get the list you want:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.