Calculated Column (pop up/asking for parameter) RRS feed

  • Question

  • Good morning-

    Without using List Validation settings (which I haven't got access to), is it possible to create a pop up inside an IF..THEN which asks for a parameter, within a calcuated column?

    In other words, can I do something like this (but I know this specific text doesn't work):

    IF ([For Life] = "Yes","N/A",[enter ending date])

    The result I'm looking for is that if the user selects Yes in the [For Life] column, then the calculated column would show "N/A", otherwise, there would be a pop up (similar to what happens in Access) asking for the ending date, and then the date entered appears in the calculated column.



    Friday, May 8, 2015 4:08 PM


  • You cannot achieve this using OOB calculated column.

    Instead use sharepoint designer workflow with following steps...

    • Set workflow start option on Item creation
    • Add an association form with checkbox [For Life] and date picker control [enter ending date]
    • As association form is a InfoPath form, you can enable/disable the date control based on the checkbox selection
    • Then within workflow set the current item field with proper value from initiation form

    Hope this will help you. If you want I can provide you a workable demo on this.

    Avijit Sur

    • Marked as answer by Casey_M Thursday, May 14, 2015 8:53 PM
    Friday, May 8, 2015 5:00 PM