Linking cells that are dependent

This is going to be a tough one to explain, and I'm not sure if it's possible. That said...:

Endstate: For a finance-based sheet ("Sheet 1"), I want one of the values from a user's form (Amount USD) to populate in another sheet (Sheet 2").

Problem: There is a debiting manager (losing money) and crediting manager (gaining funds) along with the dollar amount for Sheet 1. Is there a formula string (maybe an IF THEN) that can check for a name in Column 1, Sheet 1 and Column 2, Sheet 1 - then populate the dollar amount in Sheet 2 based on the name in Column 1 or Column 2?

I'm not explaining this well, but anyone who can link up to help me will have earned a lunch (liquid or otherwise).

Find more posts tagged with

Finance

IT & Operations

Comments

SYSPK

Sounds like INDEX/MATCH would be useful (google to find articles and video) but I believe the manager names that are to be matching must be spelled the same.

Maybe there is another formula like FIND instead of MATCH that can give approximate values? Maybe someone else can chime in here.

Edit to add: INDEX/MATCH works differently in Smartsheet than it does Excel, so make sure you're looking up a Smartsheet resource.

L_123

=index({dolla bill #1},match(name,{name 1},0))+index({dos dolla bill},match(name,{name 2},0))

Provided the names are spelled correctly in every occurance something like this should work.

Sign in to join the conversation!

Quick Links

Trending discussions

Automating Quarterly/Annual Reminders
I need to setup automations based on a contract date that will notify me on a monthly/quarterly/annual basis so I can process paperwork at the appropriate time. Ideally, I'd like to set it up to send an email 90 days before that date. I have columns for the initial contract date and the frequency (one for the word…
Deleted so much data
Good Morning, I was working too early and after vacation and deleted some needed information from a report and it changes all my workbooks. I did the download for the history however it doesn't show me the data that was in the cells. Is there any way to get that information?
Automations
Hi everyone, Is there a way in Smartsheet automations to maybe export all of them to an excel sheet or something so that you see all of them in one place? The reason I am asking is that we are working with a Smartsheet that someone else created that is no longer with the company. There are 46 automations. The sheet itself…