Pulling Approved Data from an Approved Row to a Version

I have talked to Smartsheet Support on this one, but I am under a time crunch, so I was hoping one of you Smartsheet wizards can help me solve the following situation:

I have a Tracker sheet that contains requests that go through an review/approval workflow
Once approved, there is a 'Latest Approved' column (checkbox) that designates it as the most recent approved version (based on Created Date) of a specific request
I have a form where requestors enter a new version--just by entering the request number and version number. These versions are deposited on the same Tracker sheet as above
CHALLENGE: I want to populate the values for ~20 columns from the most recent approved version. This will then allow the requestor to change any values required for the new version and retain those values that are unchanged. Here is the formula that I have right now for the 'Traveler Name' column: =INDEX(COLLECT([Traveler Name]:[Traveler Name], [TAR #]:[TAR #],[TAR #]@row,[Latest Approved TAR]:[Latest Approved TAR], 1),0)
Currently I am getting a '#CONTACT EXPECTED' error message in the cell, which makes it seem as though I am close

I welcome any ideas on how I might be able to accomplish this--either fixing this formula or via another method. If I can't, I will proceed with my current solution which involves two separate Tracker sheets. This would not only streamline the process, but it would also be more effective.

Thanks in advance!

Steve

Find more posts tagged with

Accepted answers

Leibel S

Not sue exactly what you are looking for but our column seems to have a slight error, see below revised:

=INDEX(COLLECT([Traveler Name]:[Traveler Name], [TAR #]:[TAR #],[TAR #]@row,[Latest Approved TAR]:[Latest Approved TAR], 1),1)

All comments

Leibel S

Not sue exactly what you are looking for but our column seems to have a slight error, see below revised:

=INDEX(COLLECT([Traveler Name]:[Traveler Name], [TAR #]:[TAR #],[TAR #]@row,[Latest Approved TAR]:[Latest Approved TAR], 1),1)

Steve@HII

@Leibel S Such a simple fix! That allowed my formula to work...HOWEVER, when I copied that same formula to the next row, it is resulting in a #CIRCULAR REFERENCE error. So maybe this is not going to work after all. I am attempting to pull data from an earlier row that has been approved for any 'Revision' row that is added. It is difficult to explain the exact scenario

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.