sorry I may have worded my question wrong... I created a custom field called "production lead time" on POs that uses a custom formula for dates. I want to add this field as a column on my existing open PO report

If your field is dynamically populated with a formula, it might not be stored on the record. You need to store the value to be able to see it in reports/searches.

if i store the value it doesnt show on the transaction... also still doesnt show as an option to add to report.

1. Stored values do show on the transaction, if you do not see it (and the display type is normal) it is most likely hidden on the form. 2. You may want to try changing to formula to something like

ROUND({today}) - ROUND({trandate})

storing the value lets me add it to report but it shows up blank... i switched it to ROUND({today}) - ROUND({trandate}) too

Can you not just add the formula column to the report instead (I hate reports so I almost never use them)

negative