Web Forms Best Practices for multiple entries
What is the best practice for a Web form that requires some header information such as Company name, Address, PO#, etc. and then it requires information submitted for multiple products. For example, we need product information for 8 separate products from the same company, and we want to avoid the recipient of the form…
Sorting recommendations when you have summary rows on the top on your sheet
I am experiencing issues when sorting a sheet and have summary rows at the top. For example, I created summary rows on rows 1 through 10 with formulas and totals, and when sorting, my summary rows get lost in the sorting process. Do you have a workaround to prevent this from happening? Ideally, I would like my summary rows…
Feature-Request: Prevent overwriting in multi user environment / Lock cells
Hi, There is a big problem with multiple users working on the same sheet. We lost several times the work of each other. Other online tools lock the cell currently under work (like google sheets). I know you have a workaround for this problem: https://community.smartsheet.com/discussion/overwriting-changes-multiple-users…
Setting up Project Management
Hi - I am creating a project management template for events. One of my tasks is sending out emails to customers. We don't send emails on Mondays or Fridays, so if I build out my dependancies, is there a way to exclude Mondays and Fridays only for those rows? I know I can set up parameters for the project but can I set…
Possible searching "symbols" (star, flags, etc.) using search bar?
Hi, By using the search bar at the top of Smartsheet I am able to find almost everything in a sheet, but a symbol. For instance, for column symbols "flag" (on/off) or "start" (on/off"), is there any syntax that would search for all rows containing "stars"? Thanks, Carlos
Calculating Days - Error if no date is entered
I have a column called "Closing Date". I also have a column that calculates the number of days until the closing date. It works great if I have entered the closing date. However, if we don't know the closing date yet and leave that column blank I then get an error in the column that is calculating the closing date. Anyway…
Save document with dismissed filter
I have my document saved with an applied filter. Now I cannot save it with the same filter dismissed. I can only change the filter and the change is saved. When I dismiss the filter and do save and re-open the document I have the last saved filter applied. Is it a bug or a feature? I have a workaround of "Select All"…
Populate Date Column Based on Primary Date Column (taking into consideration workdays)
I am attempting to automatically populate a date column when a "due date" column is filled out. The dependent date column would always be a date 3 working days after the due date unless manually changed. I have been scouring dependency columns and if then statements but I can't seem to figure out something that seems like…
Snartsheet Site does not allow for links to local recources.
Thank you all in advance for taking a look! We have created a site servving as consolidatoin point for all our department sheets. We wanted to include a link that would launch an excel stored on a local drive however when we use the widget, it auto populates the field with "http://". This renders our entry to a local path…
Friendly Web Form URL
Is there a way to create a "friendly" web form URL?