Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Conditional Cell Linking
I could use some help on something I'm trying to do in SmartSheet.
Scope of Project:
I have a master inbound "Lead Tracker" sheet that I use to keep track of referrals sent in from various business partners. I would like for these business partners to have access to their own "Lead Tracker" as well which would contain information pushed to it from my 'Master' Lead Tracker. Their personal Lead Tracker would be accessable from their own personal Workspace created for them.
I cant seem to figure out how to enable my 'Master Sheet' to push data to the destination Lead Tracker after I assigned the lead to it using list collumn in my master sheet entitiled "Lead Source".
Example: If I select 'John Doe' as the lead source in a row on my Master Sheet I want all data in that spacific row to be pushed to John Doe's - Lead Trancker and updated as changes are made on my Master Sheet.
Any suggestions would be greatly appreciated!