When trying to make an automation to import data from a spreadsheet (Excel/Microsoft 365 environment) to clickup, the Watch Worksheet rows doesn’t read the populated rows but reads all rows where the formulas are triggered. (ex from 0 to 500)
INFOS:
1.The formulas inside the worksheet produced initially 0 content (some of them) then i introduced some =IF(cell=0,“”,cell) to produce “blank” content but they are still populated with formulas, up to row 1000. If i delete 600 rows, indeed the Make Excel Watch Worksheet reads up to the last row <populated with formula).
2.The clickup ID’s matching with the raw data incoming in the spreadsheet is done by several spreadsheet formulas (eg. vlookups, match, index)
I have a similar scenario that works with google spreadsheets, and it properly reads the last updated row, even if those are also generating content with formulas also.
Could soomeone
please advise?
If i leave it like this, when i run the automation (with let’s say 25 cycle execution limit) it goes over the actually documented rows containing data, then after 15 minutes, the next 25 are getting bundled, and it’s introducing blank data into clickup.
Initially i saw this looping tendency because some after the automation checked the last actually updated/populated row, it outputed a bundle error (not matching CLICKUP ID’s for example, “0” value instead of a “d22b404f-1fe6-4cf8-9d43-62191bd5c307”, and it maked sense, since it went to the next row containg 0.
But how do i make this automation actually watch the new rows when they get actual data retrieved from formulas?
