One Drive Excel

Occasional Contributor

Team,

 

I am having excel file inside the One drive. Following is my requirement.

 

1. Row inserted date and time 

 

Tried with following but not working . 

A5(Column) any number and this formula is kept in Column A6 

=IF(TODAY()>A5,NOW(),"Active")
 
But this is replacing all date with current date.
 
2. i need to the email id who is placed the file inside the shared folder.
 
 
 
0 Replies