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
Admin User 3585Admin User 3585 

Last Activity Date in Task

Hi,

How to create new fields in Task page.  My requirement is I want to capture the day the user updated their activity in Task.

IF(TODAY() = LastModified Date, "Today", IF(ISBLANK(Last Modified Date),"Never", TEXT(TODAY()-Last Modified Date) & " Days Ago"))

Sudarsan
Naval Sharma4Naval Sharma4
Hi,

I think creating a formula field with what you mentioned will work for you.
  
IF(TODAY() = LastModified Date, "Today",  TEXT(TODAY()-LastModified) & " Days Ago")