SteveReed@WK✭

创建soluti @Sammy伊斯特伍德,我on right now for exactly that scenario--a workflow tracking two levels of audit artifact reviews--and my client has requested that we capture Approval dates. After review, the reviewers can either Approve or Decline an artifact, and I use Andree's row copying method above to capture…

@Paul Newcome In trying to determine whether this method actually works, I visited both pages this morning. My conclusion is that it is still reliant on physically visiting the page. Below are screenshots of the Activity Logs for the two pages. First is the page that houses today's date that is locking/unlocking overnight.…

@Paul Newcome Maybe I am missing something here, but I duplicated your setup yesterday: created the TODAY sheet with a Date column populated with =TODAY() created Lock and an Unlock automations on the TODAY sheet scheduled to run at 1:00 and 2:00 am set up a cell link from my other sheet in a Date column When I went into…

@Paul Newcome I have a follow-up question to your solution. If you want to avoid locking the main sheet (even in the middle of the night), couldn't you also do that with a secondary sheet and then cell link that to your main sheet? You had mentioned that a cell link update would also refresh the TODAY function.

I wanted to provide a link to the solution that I found for my question above. Thanks to Paul Newcome and ToddF for their insight and expertise to solve this challenge, which was potentially a huge obstacle to my Smartsheet solution. You can find the details here:…

I 100% AGREE WITH THIS ENHANCEMENT IDEA! The way this displays now, it appears as though something is broken, rather than there just being no data to display. I would rather see an empty chart. Even the message that shows when a report based on Current User (something like, "there is no data for this user") is better than…

Andree, I have a question for building on this trick to capturing a transaction date. I am trying to use this approved date field (derived via VLOOKUP) to trigger the next step of a workflow. Here is the scenario: 1 - someone posts a document and that Posted Date is captured via the above method 2- I am using that date…

Paul - YOU ARE THE MAN! I actually just tried your LEFT solution after changing the . to -, and it works beautifully!!! ? This is so much better than having to call out all possible file types. Thanks so much! Gotta love the Smartsheet Community! Steve

Thanks for the reply Paul. Unfortunately, right now the plan is that the file names would contain at least one other "." The items on the tracker sheet are like this A7,1, A7.2, A7.3, and A7.4 to correspond to a required document for each of Q1, Q2, Q3, and Q4. If I replace the "." with something like a "-" in the tracker…

Thanks for the reply Ben, but unfortunately that is the one thing that I do know about this whole scenario--how to find the sheet number. I can handle the Smartsheet application side, it is just everything outside the configurable world that I need help on! Thanks for trying anyway! I appreciate the effort. Steve