I want to create a column by using the other column's data. For example :
There are Modified Date , Modified By , Name columns. I want to create a new column by using Modified Date. If Modified Date is TODAY , want to call it "NEW" or "EXPIRED" .
Is it possible with Sharepoint? thanks.