Most Recent Update -- Report or Sheet

@Genevieve P. @Paul Newcome

We are beginning to use our SS Log to record when we open and close terrain. We want to collect the when, ie our [Date] and [START Time] (still getting requests for a time stamp option). We then want to show the Terrain's current Status as Open or Closed. I am hoping to have a separate sheet and possibly Dashboard. I tried to work some formulas but either get "0" or Invalid or .... Below is the SHEET we are using to collect the information. It could be that a section of Terrain would open and close and open throughout the day (not common but possible).

SIGNLINEDATA.PNG

I would like to collect the most recent data in the sheet below, So that the [Sign Line] would already be filled out and Static, but the date and status would be Dynamic based on the updates to the sheet above.

SIGNLINE BLANK.PNG

Any help would be great. Also the first sheet was displayed with a filter, there is a significant amount of other data being recorded, but we wanted to keep this info in the Daily Log so that we are not opening and closing sheets....

Scott

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!