Skip to main content
added 121 characters in body
Source Link

Do not try and built a complex formula in one go.

Take it step by step; make LeaveType="Casual Leave" work first..

You have already written down the pseudo code in your description,
Now... best done in Notepad.. rewrite the description into a Formula..

Once you think it might work, paste it into SharePoint... If it fails.. go back to Notepad..

Tip: copy paste each try as a new paragraph in Notepad.. you learn from reviewing previous mistakes.

If Leave Type=Casual Leave 
   then I have to compare the field casual leave 
       in PTO Available 
   and I have to 
       subtract the calculated days of that particular column 
and the result should be 
    in Current PTO YTD 
    in Current Casual Leave PTO YTD .

Notes:

  • Calculated Columns can not set a value in another Column, you need a Workflow for that

    Calculated Columns can not set a value in another Column, you need a Workflow for that

      IF([Leave Type]="Casual Leave"
         ,"I have to compare the field casual leave"
         .....
    

Do not try and built a complex formula in one go.

Take it step by step; make LeaveType="Casual Leave" work first..

You have already written down the pseudo code in your description,
Now... best done in Notepad.. rewrite the description into a Formula..

Once you think it might work, paste it into SharePoint... If it fails.. go back to Notepad..

Tip: copy paste each try as a new paragraph in Notepad.. you learn from reviewing previous mistakes.

If Leave Type=Casual Leave 
   then I have to compare the field casual leave 
       in PTO Available 
   and I have to 
       subtract the calculated days of that particular column 
and the result should be 
    in Current PTO YTD 
    in Current Casual Leave PTO YTD .

Notes:

  • Calculated Columns can not set a value in another Column, you need a Workflow for that

Do not try and built a complex formula in one go.

Take it step by step; make LeaveType="Casual Leave" work first..

You have already written down the pseudo code in your description,
Now... best done in Notepad.. rewrite the description into a Formula..

Once you think it might work, paste it into SharePoint... If it fails.. go back to Notepad..

Tip: copy paste each try as a new paragraph in Notepad.. you learn from reviewing previous mistakes.

If Leave Type=Casual Leave 
   then I have to compare the field casual leave 
       in PTO Available 
   and I have to 
       subtract the calculated days of that particular column 
and the result should be 
    in Current PTO YTD 
    in Current Casual Leave PTO YTD .

Notes:

  • Calculated Columns can not set a value in another Column, you need a Workflow for that

      IF([Leave Type]="Casual Leave"
         ,"I have to compare the field casual leave"
         .....
    
Source Link

Do not try and built a complex formula in one go.

Take it step by step; make LeaveType="Casual Leave" work first..

You have already written down the pseudo code in your description,
Now... best done in Notepad.. rewrite the description into a Formula..

Once you think it might work, paste it into SharePoint... If it fails.. go back to Notepad..

Tip: copy paste each try as a new paragraph in Notepad.. you learn from reviewing previous mistakes.

If Leave Type=Casual Leave 
   then I have to compare the field casual leave 
       in PTO Available 
   and I have to 
       subtract the calculated days of that particular column 
and the result should be 
    in Current PTO YTD 
    in Current Casual Leave PTO YTD .

Notes:

  • Calculated Columns can not set a value in another Column, you need a Workflow for that