Is there a way to deny being able to check a box complete until an attachment is added.
Thanks in advance
Hi Dustin,
I have a few ideas!
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Certain tasks get assigned to different people in my company. Some of these tasks but not all require attachments (i.e. construction drawings, permit applications, estimates) I don't want the assigned person to have the ability to check a task as completed until they have attached a document.
Ok.
Do they need to be able to change other things in the rows before they attach the file?
Andrée
Just a completion date.
Sceenshot
Andrée when you say you have a few ideas, are you implying you know of a way to check for attachments? If so, you will be my hero!
I will refresh this thread every 10 minutes looking for a solution!!!
My thought would be to use the Unlock/Lock row actions, and that might still be an option depending on permissions needed.
Another option could be to use a third-party service like Zapier or similar to check a box when an attachment is added and if it's not checked when trying to complete it would show an error or/and send a message to you.
Would that work/be an option?
How would you like to use it?
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
