Filter Rows based on Attachment
Can a table of information be filtered to show rows that include (or don't include) an attachment associated with that row?
Best Answer
-
Hi Brian,
Yes, it can. See below.
Would that work?
I hope that helps!
Have a fantastic week!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi Brian,
Yes, it can. See below.
Would that work?
I hope that helps!
Have a fantastic week!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
cant believe i missed that. Thanks for your quick response!
-
Easy to miss!
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
How did you get that option of 'Row' please?
I have searched for it in the dropdown, and also typed it....nothing :(
-
Hi @L Darvesh
The images above are using a Sheet to create a filter. This looks like you're using a Report, is that correct?
In a Report, you'll need to filter by cell contents. What I would do here is have an automation on the underlying sheet(s) to automatically check a box if an attachment is added to the row. Then you can filter your Report by that checkbox 🙂
-
Thanks very much. Not sure why they would offer the feature on a sheet but not on a report, but thanks for your suggestion, it's a good workaround. :)
