If there's an attachment, fill cell like this. If no attachment, fill cell like this.

Carlyn F

I'm trying to put an automation in my smartsheet to fill in a column stating whether something is attached to that row or not. The row is completed by a form. I can get it to fill in the cell if there IS an attachment, but I can't figure out how to tell it what to fill in if there is NOT an attachment. Seems pretty simple, but I'm stumped!

Paul Newcome

How exactly are you currently getting it to fill when there is an attachment?

Andrée Starå

Hi @Carlyn F

I hope you're well and safe!

Try something like this.

• Workflow that checks if there's an attachment and if yes = Change cell
• Otherwise = Change cell

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Carlyn F

The trigger is still predicated on a row being added with an attachment. If there is no attachment, the workflow does not get triggered at all. Right now, if a row is added with an attachment, then I'm changing a cell value to reflect that there is an attachment on that row. If a row is added with no attachment, I need to change a cell value to reflect that as well so I can request whoever filled out the form to follow up with the proper attachment. Thanks so much for your continued help!

Enaph

can we push this further and capture the file name of the attachement in a row and limit the # of attachement to 1 file only per row?

Andrée Starå

https://community.smartsheet.com/discussion/comment/440949#Comment_440949

Hi,

I hope you're well and safe!

Unfortunately, it's not possible now (it might be possible with the Smartsheet API), but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!