Sign in to join the conversation:
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?
Hello! I am attempting to create a dashboard widget that shows me how much budget we are spending in each segment, and in what category. The source sheet contains these columns… "Budget" - text/number column "Category" - dropdown list (restricted to list values only) "Segment" - dropdown list (allows multiple values per…
How can I change the value in one row based off of information in that row and information in a predicessor row
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…