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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!