is there a 100 line limit on Automated Workflows

Steve Woolley

Hi there.

I have a very simple Smartsheet that i collect data in for my device deployment project. I run an automated workflow each night to show the number of devices deployed that day. I have about 20 columns of data but only include about 12 of them for the workflow report. The trigger for the workflow is the date of "today" as it runs each day at 6pm. So i don't need any other data other than "todays".

The issue i have is that the automated workflow ran at 6pm yesterday and displayed 100 lines of data but there was a note at the bottom of it to say that 32 lines had not been included !!. After checking my Smartsheet i did in fact have 132 deployments.

Is there a limit to the amount of lines that an automated workflow can include when it is triggered.

Cheers

Steve

Andrée Starå

Hi @Steve Woolley

Yes, I think so. I recognize that number as a limit I've seen before.

As a possible workaround, you could maybe split the workflow in two or more as needed.

Another option could be to use a report instead.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Steve Woolley

Yes, I think so. I recognize that number as a limit I've seen before.

As a possible workaround, you could maybe split the workflow in two or more as needed.

Another option could be to use a report instead.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Steve Woolley

Hi Andree,

Many thanks for the quick response. Very helpful and I thought that would be the answer i would receive back.

It is going to be a real nuisance for me as i have to provide the data to my client every day at 6pm and really want it to be automated. The workflow set up and reliability is excellent.... but if it is only giving me 100 lines and then missing of the remainder that's no use to me at all.

Not sure how i could split the workflow as the "date is today" is the trigger and i cannot see any other way of splitting that out as all the other info is different. Have you any ideas?

I did look quickly at the Report Builder which would give me 'all' the info but i couldn't see a way of automating this to run every night at 6pm. Is there a way of automating it ?

Cheers

Andrée Starå

@Steve Woolley

You're more than welcome!

Yes, you can set the report to send with recurrence.

More info.

https://help.smartsheet.com/articles/516096-sharing-sending-reports#toc-set-up-recurrence

Would that work?

Set Up Recurrence

You can schedule your report to be sent on a recurring basis automatically. Note that when you do this, the report will run before it's sent so that it will always contain the most up-to-date information.

To send a report as an attachment at a recurrence that you specify:

1. Follow the steps above to open the Send as Attachment window.
2. In the window, next to Delivery, click the Schedule link.
3. 
   

2.  
3. In the Delivery Options form, select the frequency with which you want the delivery to occur (Daily, Weekly, Monthly, Yearly) and specify the other recurrence options.
4. Click OK.

Once you've set them up, recurrences will appear in the right panel of the Send as Attachment form. To edit or delete recurrence, click the arrow next to the description of the recurrence.

Steve Woolley

Hi Andree,

Thanks for the response and its exactly what i have done.

I needed the extra detail on how to set up the schedule etc so i took a bit of time over the Xmas break and found how to set it up. When i used Report Builder previously, i didn't see the schedule bit so didn't know it was possible,

It all works perfectly now and has all the info i need to provide my client every night at 6pm.

Thanks. 👍️

Andrée Starå

@Steve Woolley

Excellent!

Happy to help!