I have created a form and in this form if the user chooses "remove" then I would like to require that documents be attached. Is this possible?
Conditional responses aren't there yet from what I can tell. That said, whenever I have something like this, I just included help dialogue in the form under the question I am asking. Something like this:"Please NOTE: If a removal, please include your _____ document below using the attachment option below"Or something like that. The discretionary dialogue in the forms is very flexible and helps in scenarios like you're describing. Chris
Chris is correct. building conditions directly into forms isn't an option yet. Feel free to submit a Product Enhancement Request.
In the meantime, you can use Google Forms which integrates very seamlessly with Smartsheet or you can set up an Automation workflow that will send out an Update Request to the user if the option was selected but there is no attachment on the row.
This would send out after the fact but (generally) happens within 15 minutes of form submission.
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
I need a formula that will count the day that a row is "Open" but stop counting the days once its "Closed" both instances need to display the count. Here is a formula I was trying to use. Thanks =IF([Date Closed]@row > 0, ([Date Closed]@row - [Date Opened]@row), TODAY() - [Date Opened]@row)
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.