Best Of

@Ray Lindstrom I was thinking (forms and DV both) of leveraging both the required field setting as well as logic to hide fields until others have been filled out.

Hello @Marvin Mudahy,

Based on your request, you might want to add an extra column in your sheet that can be used to identify which tasks you would like to assign to your resources and use a formula to automate the actual Task column based on the yes or no selection.

I was able to recreate the recommendation with the following column types:

Task - Primary Column - Text/Number

Assigned To - Contact Column

Accept - Drop Down (Values - Yes, No)

Task Name - Text/Number or Single Select Drop-Down

I used a column formula to automate the Task column using the following:

=IF(ISBLANK(Accept@row), [Task Name]@row, IF(Accept@row = "Yes", [Task Name]@row, ""))

I then entered the tasks in the Task Name column. If the value in Accept is blank or "No" then the value in the Task column will be blank, if the value in Accept is "Yes", then the value in the Task Name column will be returned in the Task column.

Keep in mind that if you have enabled dependencies on your sheet, then the Parent Rollup functionality may not reflect expected data if you've created a hierarchy with these rows. It might be better for your project sheet to just have a drop-down value for your tasks that allow you to assign tasks to your resources or for your resources to accept tasks they want to work on.

I hope this information helps with your request!

Kindly,

Leslie

Hi, 

I hope you're well and safe!

You could send an Update Request, and all attachments would be included.

Does that make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with 💡 ⬆️ ❤️ and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

You’ve run into one of Smartsheet’s current form limitations: each form can only include one file upload field. There isn’t a native way to add multiple upload links after each question.

That said, there are a few practical workarounds you can use depending on how flexible your project setup is:

• Create separate forms for each section/question that requires a file upload.

• Each form can have its own upload field.

• Responses will still feed into the same sheet, so you can track everything in one place.

• You can share the different form links with users or embed them sequentially in instructions.

A tedious method is to open the attachments sidebar and for each attachment click on the 3 dots and pick "Send File". this will open a Send Attachment window and you can copy the url to the attachment and paste it into a cell.

/marc