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. 😎
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!