Using a formula that involves different sheets.

Nic Sanchez

Can you use two different reference sheets in a formula?

I have a data sheet where I use a formula to add up my data (sumif backlogged money). Is there a way to write a formula to pull information from two different sheets to produce a result?

bisaacs

Hey @Nic Sanchez,

Yes this is doable! When you're writing your formula, there will be a popup window that will ask you if you want to reference another sheet:

Clicking on that link will open a window allowing you to select data from another sheet.

Hope this helps!

Nic Sanchez

That is what I thought, but when I try it, I get an error for anincorrect argument set or ref.

Andrée Starå

https://community.smartsheet.com/discussion/comment/433132#Comment_433132

Hi,

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!