Fill sheet based on another sheet (if cells contain value)
Hi Smartsheet community,
I am looking for formulas or ways to automatically fill sheet B with the information of certain columns of sheet A for all rows in sheet A that contain a value. In a dynamic way, meaning if a row is added to sheet A it should be also added to sheet B. For example:
- Sheet A has 1 column with 10 rows containing a value
- I want these exact same values of sheet A row 1 to 10 to be copied into sheet B (also into rows 1 to 10)
- if I add a value to row 11 in sheet A, then this value should be added to sheet B row 11 as well (the same should happen if I delete a value in sheet A, it should be deleted in sheet
Cell linking does not work here, since it sheet B will not contain a cell link if sheet A does not have a value.
Any ways to use the VLOOKUP formula together with IF and IFBLANK? I tried something like this without success:
Any way to make this happen? Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!