Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Archived 2017 Posts
Archives for November 2017
Discussion List
Using Web Form to Update different sheets
I am using Smart Sheets as a work order tracking tool for multiple properties. I would like to use one standard web form with either a drop down list or check box of properties. When a user selects the property they need service, the sheet attached to the property would be updated. One web form with direction to update…
Constants and Variables
I believe that there should be a way of storing a few Constants and Variables as part of the sheet but not as cells on the sheet. These could be invisible to the User apart from the Owner or Administrator, and could be accessed via the sheet menu as part of the properties of the sheet. In the first instance I would suggest…
Formula error in Nested IF Loop
Hi SS Community, Trying to automate shipment status using 'date needed by' and 'expected delivery date', but currently have an error with nested if loop #INCORRECT ARGUMENT SET, =IF([Date Needed by]1 < [Expected Delivery Date (Purchasing Agent)]1, "LATE", IF([Date Needed by]1 >= [Expected Delivery Date (Purchasing…
Formula with Update Requests
Hello all, Im using Smartsheet to automatize a lead process with around 30 people involved. We get Leads in an external network, I add them to my Smartsheet Sheet and then the one in a contact column gets an automatized notification with the new lead data. After 5 days I need an update with est. values and so on, so I made…
Multiple Photo Upload For Webform
Is there a way to load multiple photos/files using a webform. It appears that to upload a number of photos at the same time on a webform you have to go through and click on each image - individually.- It would be great & quicker to make multiple selections if possible.
Allocating tasks to external vendor
Hi there i am setting up the Christmas holiday calendar for my team. One of the resources on the project is external vendor which is based in China and will have a different holiday period to rest of the team i.e. they will be working on some of the holidays that we have. How can i set up this resource to be 100% allocated…
Gantt Chart Task Percentage Color
How do you change the color of the percentage indicator inside the bar of an individual task? In conditional formatting, you can only change the color of the task bar itself and not the color of the percentage of the task. Thank you.
Looking For a change Order Template that is fill in and can add photos or media
Looking For a change Order Template that is fill in and can add photos or media
Drop down menu in one box only
I have a housekeeping template for 150 different properties, and I want a drop down list on the top left corner in order to identify the property when it is checked. Can that be done for just one cell?
Web socket error while implementing smart search of Qlik Sense
I have followed the following code on github and cloned the directory. Qlik Sense smart search | QlikView Whenever I try to run the code, I am getting the following error. As I am very new to Qlik Sense I am unable to understand where the problem lies, can anyone please help me out on this? Regards SarahJohn