Skip to main content
SharePoint

Return to Question

formatting
Source Link
wjervis
wjervis
  • 5.7k
  • 25
  • 45

I have a field (Status Update Date) that should be updated with the current date/time when another field (Status) is changed. However, whenever ANY field in the row (datasheet view) is updated the Status Update Date us updating to the current date/time. Any ideas on how to ensure the field is only updated with current date/time when the Status field is updated?

=IF(ISBLANK(Status),1/2/1900,TEXT(NOW(),"mm/dd/yyyy hh:mm:ss"))

Thanks!

=IF(ISBLANK(Status),1/2/1900,TEXT(NOW(),"mm/dd/yyyy hh:mm:ss"))

I have a field (Status Update Date) that should be updated with the current date/time when another field (Status) is changed. However, whenever ANY field in the row (datasheet view) is updated the Status Update Date us updating to the current date/time. Any ideas on how to ensure the field is only updated with current date/time when the Status field is updated?

=IF(ISBLANK(Status),1/2/1900,TEXT(NOW(),"mm/dd/yyyy hh:mm:ss"))

Thanks!

I have a field (Status Update Date) that should be updated with the current date/time when another field (Status) is changed. However, whenever ANY field in the row (datasheet view) is updated the Status Update Date us updating to the current date/time. Any ideas on how to ensure the field is only updated with current date/time when the Status field is updated?

=IF(ISBLANK(Status),1/2/1900,TEXT(NOW(),"mm/dd/yyyy hh:mm:ss"))
Source Link
user5245222
user5245222
  • 1

Problem with SharePoint calculated field

I have a field (Status Update Date) that should be updated with the current date/time when another field (Status) is changed. However, whenever ANY field in the row (datasheet view) is updated the Status Update Date us updating to the current date/time. Any ideas on how to ensure the field is only updated with current date/time when the Status field is updated?

=IF(ISBLANK(Status),1/2/1900,TEXT(NOW(),"mm/dd/yyyy hh:mm:ss"))

Thanks!