I would like to change a cell if an attachment is received

Michael Foti

I need to send reminders to suppliers for them to attach specific files such as datasheets etc. Once the file has been received I would want Smartsheet to stop sending further reminders.

 

I think possibly a solution is for a cell to change status if an attachment is received. I could then create a logic statement which will only show a reminder date if that cell is blank. I'm not too sure if Smartsheet has the capability of changing the cell value if an attachment is received.

 

Can anybody help?

Kennedy Stomps

Hi Michael-- Brett is correct, we don't currently offer a formula operator that can "read" the attachments column, but I've added your vote for it to our enhancement request list. Our developers will consider it for a future update!

 

In the meantime, I think Brett had a good suggestion. You could include a checkbox for your users to check when they include an attachment, then run the formula off of this column. 

Brett Evans

Unforutunately there are no formulas that let you "Read" the attachments cell.  You would have to have a seperate coumn, perhaps a check box, indicating what has been attached that is marked when the file is attached.

 

It wouldn't be perfect, but I think this is your best option.

Claire Diener

+1 vote from me. this would be super helpful!

Kennedy Stomps

Hi Claire-- I have added your vote!

J. Craig Williams

Add my vote - although I think this enhancement has been requested before so my vote is likely there.

Craig

Kennedy Stomps

I've added your vote, Craig!

Judah Karkowsky

+1 for me.

 

Joseph Aulet

+1 for my team

Joseph Aulet

+1 for my team

DustinH

Found this discussion searching for how to do this.  When our tasks are complete (checkbox) we require that the documentation of that task be attached.   Really would like to set up conditional formatting with a formula that alerts/highlights if a task is complete but there's no attachment to that row.   +1 Vote

Sergiy Gavrylyuk

+1 A very useful feature

Clark Walliser

Add my vote.

Does Smartsheet community have an enhancement request function with votes collection?

It seems doing this manually by posting a comment is pretty difficult on your side. 

J. Craig Williams

Clark,

See this post:

https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests

and 

https://community.smartsheet.com/discussion/community-suggestion-submit-product-enhancement-requests

Craig

Keith Tham

+1 vote for this as well.

Want to set condition that there must be attachment before can submit.

Thank-you,

-Keith

 

Ashik Ratnani

+1 from me as well. Specifically, I would like to extract the attachment date, and use it to do some conditional formatting based on how old the attachment is.