Fetching specific cell data from excel once row is selected

Question

COL$W:COL$X: Not CoachingCOL$Y: Not CoachingCOL$Z: Not CoachingCOL$AA: Not CoachingCOLSAB: Not CoachingCOL$AC: Not CoachingCOL$AD: Not CoachingCOL$AE: Not CoachingCOL$AF: Not CoachingCOL$AG: Not CoachingCOL$AH: Not CoachingCOLSAI:I have the above data popped out as an output of the previous step in zap.This data is not in table format but it is an individual line for say "COL$X: Not Coaching" is one line next to that is another line.This data is fetched from excel.Now what I want to do is from this data, I have to select all those values which have a blank value assigned.For example - COL$W:, COLSAI: in the above I tried figuring out if I can search through each column of the respective row after getting that row selected with the look-for rows. But wasn’t able to do that using the loop function or even using code.I think the way to do that is to convert this into a table and then fetch the respective rows having blank values assigned. However, I didn't figure out any way to do so in zapier.Please guide me If I am missing anything here or if there is any other alternate and better way to do this.

RALaBarge · Accepted Answer

Hey there @Tushar!I think I understand what you need to do -- you need to flag or highlight cells that have no value in the rows that we return for you, is that correct?It also sounds like you were hoping to iterate through an entire sheet via Zapier to examine all or some of the data relative to the blank cells you found. Is that correct?I can say that Zapier does not have any ways for you to iterate through an entire sheet based on a row being returned to us. Zapier’s spreadsheet actions are built around the “Rows” but not the “Columns” as well, which sounds like it will limit your ideal workflow here.Zapier can tell you what fields are blank being returned to us, but you would accomplish this by evaluating every single cell and compare that to a blank string. You can find details on that in this help guide, but it would be very task intensive as you would need to do this evaluation on every single string being returned. One could accomplish something similar using a Code Step, doing a similar evaluation and only use 1 task for all of the strings instead of 1 task per string to compare.In the end I’m not sure Zapier would be a great fit for what you are trying to accomplish here with our standard apps, but since we do offer Code Steps you could theoretically accomplish some of the things you were trying to do with this workflow idea.Let me know what questions I can answer for you!

Tushar · Answer

@RALaBargeThanks for the revert.Yes, you understood that correctly. What I want to do is after getting a respective row, I wish to navigate all available columns of that sheet in a returned row to figure out which are having blank values assigned and then move that data to the next step.SoI will try to do that using excelformulas and code steps in zapier if I can.Hoping to crack that soon.Cheers.

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded