• Resolved shumilica

    (@shumilica)


    Hi and thank you for a great plugin.
    I wonder if there is any chance of being able to add data trough this plugin and still have formulas in the sheet?
    I am using this kind of formula in the header row so that there is no value in the row before inserting something in the cells that relate to the formula:
    ={"Spent";arrayformula(if(isnumber(A2:A),B2:B-A2:A,))}

    When I’m using this gsheets connector enters a loop (or something) and puts the data inserted into the form at the last possible row (50001).

    I’m thinking more like an option within the plugin where you can specify to only check first column if it’s empty or not, if it’s empty write on that row (even if some columns have some data – the formulas). Or some kind of workaround. I don’t know the limitation of google sheets API but for example AutoCrat plugin can write on a row where there are some other data (it creates new columns after the last occupied column) so I think it’s possible.

    Thank you

Viewing 1 replies (of 1 total)
  • Plugin Author westerndeal

    (@westerndeal)

    Hello @shumilica,

    Thanks for the suggestion,
    Currently there are no such features,
    Will keep in TO DO list for above feature on future release.

    Regards
    Abdullah

Viewing 1 replies (of 1 total)
  • The topic ‘Data entry in a sheet with formula’ is closed to new replies.