Welcome!

formula to check box if attachment is uploaded

I wanted to create a formula to check a box if an attachment was uploaded on a row but I haven't run across this function yet. Does smartsheet allow this?

Find more posts tagged with

Comments

Andrée Starå

Hi Wendy,

Unfortunately, it's not possible at the moment because there isn't a way to use a formula with attachments, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

As a possible workaround, you could have an Approval Workflow triggered when an attachment is added and have that change a status column that then could check the box.

Would that work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Scott Willeke

Wendy: As Andrée already said, there isn't a formula for this but Automated Workflows with a properly configured trigger might get you close. Could you tell me more about the use case you have in mind for this? If it is easier for you to discuss on the phone, please use this link to set up time with me to discuss.

--

Scott Willeke | Smartsheet

Director of Product Management

Taylor U

Hi Andree,

Sorry this is a late response, but I'm interested in this process as well and have been trying to set up an Approval Workflow like you mentioned--it's currently set up with the trigger being that an attachment is added but I'm confused about the second part on changing the status column. My next action after the trigger is to request an approval but how would I set it up to check a box? The column is currently formatted as checkbox. Thanks for the help!

Andrée Starå

Hi Taylor,

No worries!

Let's say that you have an Approval Workflow that changes the Approval Status to "Submitted" we would then use that in the checkbox column.

Try something like this.

=IF([Approval Status]@row = "Submitted"; 1)

The same version but with the below changes for your and others convenience.

=IF([Approval Status]@row = "Submitted", 1)

Depending on your country, you’ll need to exchange the comma to a period and the semi-colon to a comma.

Make sense?

Have a fantastic weekend!

Best,

Andrée

Karla Bumann

@Scott Willeke Curios if there has been any progress in development or releasing a new Smartsheet feature that would allow us to reference attachments in a formula. I too have a use case for this enhancement request. Has it been added to your roadmap?

Secondly, I'm struggling with the concept of an "Approval Workflow" that would change a status column. Can you explain further please?

Thanks,

Karla B.

Sign in to join the conversation!

Quick Links

Trending discussions

Week Number Year to Year
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
Use Sheet Summary as cell reference for a different sheet
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
Issues with IF formula
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…