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
Best 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?
Answers
-
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?
-
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?
-
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. ๐
Help Article Resources
Categories
Check out the Formula Handbook template!
