Link across sheets

wting · 01/15/24

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

Paul Newcome · 01/16/24

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?

Paul Newcome · 01/16/24

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 · 01/16/24

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 · 01/16/24

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 · 01/16/24

Happy to help. 👍️

Link across sheets

Best Answer

Answers

Help Article Resources

Categories