Is there a way to count the number of attachments in a row?

Xochitl C. · 02/05/24

Hi there,

I wonder if there is a way to count with a formula the number of attachments in every row. To give more context, I have created a form to submit excel documents every day by my team, so every entry/row may have more than 1 attachment and I'm trying to measure their productivity and progress every day. I also have included 2 system columns (created by and created date)

Any insight is much appreciated!

John_Foster · 02/05/24

HI @Xochitl C.,

This is not currently possible, but it is a great idea. Please submit an enhancement request for this if you would like.

Submit an enhancement request

Thanks,

John

Andrée Starå · 02/07/24

Hi @Xochitl C.

I hope you're well and safe!

You could add a field in the form where they have to select the number of attachments.

Also, you can add a workflow that counts each time an attachment is added to the row, but it can't count the number of attachments added on one occasion.

Make sense?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

John_Foster · 02/05/24

HI @Xochitl C.,

This is not currently possible, but it is a great idea. Please submit an enhancement request for this if you would like.

Submit an enhancement request

Thanks,

John

Xochitl C. · 02/05/24

https://community.smartsheet.com/discussion/comment/417776#Comment_417776

Thanks John I will!

Andrée Starå · 02/07/24

Hi @Xochitl C.

I hope you're well and safe!

You could add a field in the form where they have to select the number of attachments.

Also, you can add a workflow that counts each time an attachment is added to the row, but it can't count the number of attachments added on one occasion.

Make sense?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Xochitl C. · 02/07/24

https://community.smartsheet.com/discussion/comment/418281#Comment_418281

Hi @Andrée Starå thanks for your insights! Initially I tried adding the column/field for the number of attachments, but sometimes they get the number wrong. I will submit the enhancement request. Thanks for your help!

Andrée Starå · 02/07/24

@Xochitl C.

Excellent!

Happy to help!

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

Is there a way to count the number of attachments in a row?

Best Answers

Answers

Help Article Resources

Categories