-
Drowndown list accessible via link to other smartsheet - Form
Do you know how we can create a form where one of the filed is drowndown list to be chosen from the list stored in other sheet ?
-
Auto Change Color or send a reminder / Notification
Hi, As per attached screenshot, The stock level is 3000, When the week 12 / 13 / 14 below the 3000, can the stock level cell auto change color or send a reminder via mail? Thanks in advance.
-
Multiple Checkboxes give different Text values
Hi, ok I have 3 columns with Check boxes, each one with a separate word, "Pre-Screen, Development, Test. I want have these word values show up on the same row in a different column when I choose the Checkbox. I can get it to work for just 1 word on the row, how do I add the others in the formula so what ever checkbox is…
-
One stop shop for Project Managers
We use SharePoint for our project information, forms, and such and we use Smartsheet for our project schedules. I would like to be able to link the log in page in SharePoint so when my PM's click on the Smartsheet button in SharePoint that they are provided with the login screen to Smartsheet and get into their one or many…
-
Comments
Is there a way to make the comments field - show in the main sheet with all the comments? Apparently it is too hard for my users to go to the comments box -any suggestions on how to achieve the same result?
-
Use system column in gantt view
Hi folks, I remember there was a way to use a system column (auto creation date, for example) in the gantt view...the trick was to create another date column and use the =created2 (or the number of the row).... but it will not work (smartsheet will transform the formula in text). I tried the same formula in a normal…
-
Approval Notification
I have a Smartsheet setup where a form is used to populate the columns. I receive an approval request and once I approve it goes to one more approver. After the "approve" button is selected, an email shows up with the following subject line: "Subject: Confirmation: Your update has been submitted" Is there a way to turn off…
-
Web Forms - The ability to Submit and Add New entry
We utilize Web Form option to track Support Cases. If a user has multiple cases, they currently have to submit their first case then go back into the URL for the Form to enter another case. Is it possible to have an option at the bottom of 'Submit and Add New', eliminating the need to go in and out of the form?
-
Calendar does not open in current month
Hello everyone, I have a Smartsheet calendar that has recently started to act a bit funny. It´s nothing major but it gets annoying. Basically, every time we open the calendar, it shows January 2017, which was when we created that sheet. While it is not a terrible error, it does take time to roll down to the current month,…
-
Define working days without affecting the calendar
My team travels for business frequently and we need to keep track of the weekends they have traveled on so everyone can get their days in lieu. I used the NETWORKINGDAYS formula and it looked fine. The problem is our weekends are Friday-Saturday instead of the regular Saturday-Sunday. If I enable dependencies to configure…