locked
validate for a blank field and fill in another field? RRS feed

  • Question

  • hi there

    I have a simple sharepoint list with 4 colomns.

    Name
    date
    id-nr
    availability

    now I want a validation to be done;

    when "Name" is filled in I want "Availability" to be filled in with "Closed"

    I tried the following: =IF(ISBLANK[Name], [Availability]="Open",[Availability]="Closed")

    but does not work

    can you guys help me here?

    Kind Regards

    Tuesday, December 8, 2015 12:40 PM

All replies

  • Hi

    use this formula

    =IF(Name="";"EMPTY";"NOTEMPTY")



    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Tuesday, December 8, 2015 1:33 PM
  • Hey,

    when I try this I get following error:

    " The formula contains a syntax error or is not supported "

    I have put the validation in:
    Settings > Validation settings

    kind regards

    

    Tuesday, December 8, 2015 1:40 PM
  • hi

    try to replace ";" with ","


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Tuesday, December 8, 2015 1:43 PM
  • hi

    tried your previous post, but still not working

    used: =IF(Naam="",Availability="Open",Availability="Closed")

    Tuesday, December 8, 2015 2:40 PM
  • Hi

    I think here it is a misunderstanding

    My fomula can be applied as a formula for a calculated column!. This way you can't fill this type of column later manually

    Another approach is to use a workflow which will fill a standard text column with needed value based on your conditions


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Tuesday, December 8, 2015 9:08 PM