#Picklist Dependency0 discussing

@Thomas Rawling

• Make sure that the formula field's return type is set to "Date". If it's set to "DateTime" or any other data type, it will not display as expected.
• Ensure the formula's syntax is correct without extra commas or parentheses.
• Verify that the picklist value matches exactly as it appears in the formula. This includes checking for trailing spaces, capitalization, and any special characters.
• Sometimes, the formula fields do not recalculate until the record has been updated. Try editing and saving the record to see if the formula recalculates.
• Confirm that the formula field is placed on the page layout and that the field-level security settings allow you to see the field.
• If there are any dependent picklists or other fields that are related to this formula, ensure they are set up correctly.

IF(
    ISPICKVAL(Type, "Adventure Camp A (Residential) 22nd – 26th July 2024"),
    TODAY() - 42,
    TODAY()
)

This will test if the formula can correctly calculate a date based on the current date. If this works, then gradually build up to the desired formula, ensuring each step works as expected

Hi Mit,

Then I would create a record type on Cases and remove this Phishing value on Case Reason from the record type. Users will therefore be able to use other values on the picklist itself.

Now, your screenflow should still be able to update the Case Reason to Phishing. One thing, your screenflow may need to run in system context instead of user context (in the flow, click on the gear icon -top left> Show Advanced> How to run the flow> System Context with/without sharing)

Are you trying to create a "normal" date field and is this in the default formula? If so, you cannot use a field on the record:

https://help.salesforce.com/s/articleView?id=000392562&type=1

Q: I am trying to reference a field on the record in the formula for the default value of a field, but it is not available

A: Default values are only available on creation of a record. At that point, no field has any value until the record is saved, hence why you cannot reference any field on the record itself.

You could use a record-triggered flow to populate the field, but this would only show after saving, or you could use a Quick Action and add a predefined value for this specific field

What you need to do is to create a formual field that will return a date, or as stated above, a record triggered flow to update the date field