Skip to main content

Novice question here, 

 

Got an IF action in my bot which is looking at an excel row, for the index value I want it to always be a certain column (in this instance it's column G)

 

My question is, would the index number be 6 (suggesting that column A and the index starts from 0) or would it be 7 (suggesting that column A and the index starts from 1)?

 

Thanks

Jonny

Hi @Jonathan Hart​ ,

 

Index Refers to Column Numbers but Index starts from 0 and Name refers to the Header of the Column


Thanks for this, so in my instance where the value I'm looking at is in column G (the 7th column) my source value in the IF string condition source value would be: $CurrentExcelRoww6]$ ?


Reply