Selecting populated column data.


I am trying to use a logic in a form but on the sheet I want the data collected to be in one column.I have 4 columns with dropdowns and a "master column" that I want to populate from the 4 "subsidiary columns" I was able to =IF(ISBLANK([Utility compressor]19), for one column but tried unsuccessfully to nest again for the next.

Here is a screen snip. Under Equipment model I want to pull a value from the columns to the right based on a logic path in the form. The way the form is set up there will only be one entry in the row for these 4 columns.

I hope this makes sense and if you have any suggestions I'm open to them.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!