Formula cross referencing sheet via template

Hello!

I have a workflow created using Zapier so that when a new row is added to my master project sheet via a form entry it will update the first row in a template sheet and create a new project sheet from that sample sheet. This all works great with the exception I have one formula that uses a vlookup to tell the status of that project from my master project sheet - the formula comes up correct but as an external error message come up.

Is there a way to keep cross references live when creating copies of sheets??

Find more posts tagged with

Templates

Sheets

Formulas

Community Platform

Cell linking

Comments

eric.o

Hi,

Currently, we don’t have a method to allow VLOOKUP Functions or Cross-Sheet Formulas to recognize newly added sheets and automatically connect to them. But this will be considered as a possibility for future development.

However, current VLOOKUPS referencing a sheet will continue to perform as normal when referencing the sheet. Meaning if the new data added via a form meets the criteria of the VLOOKUP it should be recognized by the formula and calculate accordingly. If you're finding you're receiving an error when performing this action you'll want to submit a support ticket so we can further investigate. https://help.smartsheet.com/contact

Cheers,

Eric

Smartsheet Support

Dominique Rose Winther

Hi @eric.o , can I clarify on this? If you have a template that you use to create other documents, the only cross-sheet formulas that don't work are trying to find VLOOKUP or information in the newly created sheet, right? But nothing happens to the formulas in the new templated sheet and its formulas that link to other sheets (i.e. where you had formulas in the template, it will still work)?

In practice, it seems to be the case, but the warning it kicks up when making a template isn't clear which cross-sheet formulas won't work.

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?