I have done read/write data with excel scope app but I need to do the same in Smartsheet as well.
My requirement is that
- login to smartsheet
- search for page (Yes- Page found, No-Page not Available)
- Clear all filters and filter a specific status (only uncompleted tasks)
- Check from reference excel/pdf/any app for missing fields and update the same in smartsheet one row after another row
Please suggest how to do the same.
Thanks in Advance