Is there a formula for one sheet to recognize data from other sheets?

Apologies in advance because I'm not entirely certain how to ask what I am trying to ask.

We use Smartsheet as part of our transfer course evaluation workflow at a four-year institution. We are having to change some things in our workflow, and in setting up new sheets, I am struggling to find out if I can automate a process for my staff.

We have one sheet that is a daily report of all transcripts received by the institution the day before. We have another sheet that sets up a timeline tracker once a student is admitted. And, we have yet another sheet that gathers information on transfer credit appeals from students.

Is there a way that the data from the Transfer Credit Appeals sheet and the Report Sheet can be moved to the Timeline Tracker, wherein it would not create duplicate rows but instead update cell information. In other words, if a student is already in the Timeline Tracker, and they then submit an appeal, could the entry of data on that appeal automatically be recognized by the Tracker and update itself?

We are still very naive in our use of Smartsheet, so any help is appreciated—even if it is that we cannot do that.

Find more posts tagged with

Join

Connections

combining two formulas

Accepted answers

All comments

Corey W.

@shivara22 This sounds like a job for Datamesh, if you have access to premium features.

If not, you could try using VLOOKUP() or INDEX(MATCH()) functions to tie them together.

Paul Newcome

My suggestion would be to combine all of these sheets into one large sheet. Then you can use three separate reports to break out the columns as needed. This will allow all data to reside on the same row and all updates flow to the same place but the reports still allow users to focus on their own section of columns.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.