Link across sheets

wting
wting ✭✭
edited 01/15/24 in Formulas and Functions

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

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!