Linking

I was wondering if smartsheet linking has the capability to perform this following type of function:

If I create a Request Log spreadsheet, and one of those columns has a drop down with options, approved, hold, pending, is it possible to create a function wherein once that approved selections has been made then that row of information will flow unto another spreadsheet? Such as what we call a Functional Roadmap?

Find more posts tagged with

Healthcare

Conditional Formatting

Project Management

Cell linking

Account and User Management

Comments

Andrée Starå

Hi,

Unfortunately, it isn't possible natively in Smartsheet but you can do it with Zapier or a similar service.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

smussadi

Hello,

I think another option that might work is to setup a new smartsheet report that will read your smartsheet and only report items of a specific status. For example, your report (named Functional Roadmap?) would only report on "Approved" status' from your smartsheet. This way you can keep all the requested items in your original smartsheet. If you don't want to see "Approved" items in your smartsheet, add a filter to remove it from that view.

Good luck!

Sam

Sign in to join the conversation!

Quick Links

Trending discussions

I am an Admin, but I cannot edit the workspace
I am already an Admin of a workspace, but when I enter the sheet to edit, it prompts me that I am a viewer. Has anyone encountered this situation? In the share tab, it shows that I am both an Admin and a viewer. How could a product from such a large company have such a BUG?😫
Why is % Complete not the same between Smartsheet and Microsoft Projects
I have two identical projects with the exact same data, but the % Complete in Smartsheet is 14% and the % Complete in Microsoft Projects is 4%. Which one is correct
Report not showing all rows
I have a report that's sorted ascending by name but stops in the "T" section. When I sort it descending by name it shows the missing names after the "T" section at the top but then stops in the "A" section, but not all of them. There are 2217 rows and 19 columns in the report right now, is there a limit to how many rows I…