Sign in to join the conversation:
I may be alone in this, but the Engage Data Ninja presentation is beautiful. If all documentation was like this, it would be amazing for newcomers!
If you haven't yet, highly recommend reading this to understand VLOOKUPs better: https://www.smartsheet.com/sites/default/files/2020-09/ENGAGE2020_45SMAR_The%20Only%20Two%20Formulas%20You%20Need%20to%20Know%20to%20Become%20a%20Data%20Ninja.pdf
Hi. I'm trying to create an if statement within the "CountyCO" column that pulls in the value where a value is visible from the 3 listed columns (AZ, Counties, DE Counties, DC County). If I write a single IF statement for DE Counties, the value is pulled (=IF([DE Counties]@row = "", "", [DE Counties]@row )) but when I…