Manage project with many tasks

ALAIN-STEPHANE

Hi all ,

Happy valentine's day !

Has anyone ever experienced managing a project on smartsheet with more than 1 000 rows ( tasks ) ? I am currently trying to define a project on smartheet and I think that I will consist of 1 300 rows approximatively . I have reached 1 000 rows today , and I have the feeling that the system is becoming slower and slower , computation time is longer , and I often receive erros messages .

Is there a limit number of rows to run a project smoothly in SMARTSHEET ?

I have just switched to the GANT VIEW and activated project settings , and the situation is worse . I am afraid of doing a vain work and not being able to run my project smoothly at the end .

So I would like to receive best practises and workarounds to ensure that everything will flow properly .

For example , since my project is broken down into 3 big pahses , I consider using one sheet to manage one phase separetely , then I will summarize them in a report .

Thanks in advance !

Andrée Starå

Hi Alain,

What error message are you receiving?

Are you using many cross-sheet formulas?

I’d recommend starting with making sure that the formulas are as efficient as possible.

Are you using @row and @cell to make it more efficient?

https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell#cell

Can you tell me more about how you have it structured?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help 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!

ALAIN-STEPHANE

Hi @Andrée Starå  ,

Thanks for the response and the idea .

Can I share you my sheet , so that you will test it ?

Andrée Starå

Happy to help!

Sure! Make sure to share everything like other sheets that are connected.

Share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) (share too, andree@getdone.se)

ALAIN-STEPHANE

OK

ALAIN-STEPHANE

Just shared ANDREE ,

There is no other sheets connected for the moment and I have deleted all the confidential / sensitive information .

Thanks in advance

Andrée Starå

Thanks!

I'll take a look and get back to you!