+ Start a Discussion

How to change a picklist value when we reach a certain date?



We have a picklist with 6 values, we also have a date field called "Online Date".  We need a formula to automatically update the picklist value when we reach the online date.


We use SF Professional (no workflows)


Thanks in advance.




Message Edited by MichaelWould on 06-30-2009 04:50 PM

Hi Michael,


You can't use a formula to update a picklist, you'd need to be looking at workflow for that. What you could do, however is create a new formula field to display the required value.


I hope that makes sense.




Thanks - thought that might have been the case.  Creating a formula to display the value might be useful, thanks for the tip.