• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

sharepoint List

I have a sharepoint list In that several columns
one of the columns IsRenewal   (column type is Yes or No  Checkbox)

Based on this I have to update another column Status.
if this is checked Status =  "Working"
If Unchecked Status = " Contract"

When I checked the list items if IsRenewal checked value displays "Yes"
if we uncheck display "No"
But when ever we add new item ( I did not do any thing with "IsRenewal" column)
it displays either Yes or No

When I  updating this Status column through Console application It throwing exception

How can i do that

PLease help me

Thanks
0
LathaLiquidHub
Asked:
LathaLiquidHub
  • 2
1 Solution
 
nsyyoungCommented:
It's weirdness with the True/False or Yes/No or 1/2 of the checkbox, which maybe someone else can explain to both of us.  I think it has something to do with the boolean value, but you're trying to use a string as a comparison in the calculated field.

Anyway, I created your list in my test enviro, changed the IsRenewal column to a choice field (Yes or no, using radio buttons), and used the following string in the Status calculated column:

=IF(IsRenewal="Yes","Working","Contract")

Works fine.

I kept getting an error regarding unsupported syntax when using the checkbox.
0
 
LathaLiquidHubAuthor Commented:
Thanks
0
 
nsyyoungCommented:
You're welcome.  Why only a B?  
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now