Link across sheets

Hi everyone,

New to Smartsheet formulas. I need a formula in another sheet to check {MJS1_InSo} for non blank, and copy {MJS1_TaskName}, if true, and a few more columns to the other sheet. Keeping in sync, both ways.

Why is this formula not working? =IF(NOT(ISBLANK({MJS1_InSo})), {MJS1_TaskName}, ""). This is returning #INCORRECT ARGUMENT SET.

What am I missing?

Thank you in advance.

Kind regards,

Wilson

Find more posts tagged with

Accepted answers

Paul Newcome

You won't be able to use a formula to keep things in sync going both directions. Formulas would only be one way where first sheet can be updated and second sheet only replicates first sheet.

Have you looked into a row report instead?

All comments

Paul Newcome

You won't be able to use a formula to keep things in sync going both directions. Formulas would only be one way where first sheet can be updated and second sheet only replicates first sheet.

Have you looked into a row report instead?

wting

Thank you, Paul for your help with this. I will look into Row Report. BTW 1 way replicate might still work for what I have in mind. Would you know why the formula above is not working?

wting

https://community.smartsheet.com/discussion/comment/413665#Comment_413665

Quick follow up. Paul, your suggestion of Row Report is perfect! Thank you very much for your help. 😁

5 mins and I have what I wanted up and running. 😎

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.