function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Synthia B.Synthia B. 

Date Auto Pop after Save

When a proofreader is chosen from Proofreading Review: Reviewer 1 picklist, instead of the user choosing the date they reviewed it, I would like for the date to auto populate in the Date Reviewed field once the task is saved. 


User-added image

The below formula renders no errors but is not populating the date in the Date Reviewed field. Should I just use a workflow rule or am I missing something in the formula? 

If(Ispickval(Proof__c,'reviewer 1'), 
Today(),null)

If(Ispickval(Proofreading_Review_Reviewer_2__c,'reviewer 2'), 
Today(),null)
Best Answer chosen by Synthia B.
William TranWilliam Tran
You would need to use a workflow field update if you need the date to be static.

If you just need a date and don't care it changes daily.

then use 

If(Text(Proof__c)<>''), 
Today(),null)

Thx

All Answers

William TranWilliam Tran
You would need to use a workflow field update if you need the date to be static.

If you just need a date and don't care it changes daily.

then use 

If(Text(Proof__c)<>''), 
Today(),null)

Thx
This was selected as the best answer
Synthia B.Synthia B.
Workflow rule will be best. Thank you.