-
Cell linking effecting Last Modified date for whole sheet
I have a Main sheet with a cell that is linked to a log sheet to count total rows. whenever a form user adds a row to my log sheet it is updating the last modified date for all the rows on my main sheet. any idea how I can have this stop happening so I can send out a notification for any row that has not been updated in…
-
Automate sending update requests by date weekly
Hi , I would like to automatically have a request to employees weekly that has their time card attached or embedded by a link for them to fill in their time for specific projects. I have looked into using a Update Request but I could not figure out how to create a rule which says to have it sent to the employees on the…
-
Custom email notifications
We use smartsheet to track enhancement tickets that is logged with us, I would like to setup a "custom" email that is triggered for every phase a ticket might go to, example move from phase 1 to 2 then a custom email gets trigered with our companys custom info and details around the ticket. ? We have an outside logging…
-
Auto populate field on form
I am trying to have a field auto populate in a form, however only a portion of the field will come through. The fields that are linked have several lines of text with skipped lines. Am I missing a simple functionality so that the entire text in that field will come through?
-
Best Way to Have a Back-and-Forth with Non-Users?
I have a sheet with info for a few hundred people. For privacy reasons I cannot share it with them, because they cannot view other people's rows (a selectively hidden feature I've put in a vote for). So I send everyone their information in an update request and ask them to fill it out. I then see their answer, respond, and…
-
Create HTML Forms
I want to embed an Eloqua from into Smartsheet. Is there a way to create a form by uploading HTML that will send the form submissions over to Eloqua?
-
Contact validation in Web Forms
I have a web form for users who do not have access to the full Smartsheet. Part of the web form is an entry for a contact who has access to Smartsheet. I have alerts built into this list based on specific rules. The users of the web form sometimes mispell the contact name. The contact then does not receive the…
-
Using "Created by" as "Assigned to" for Resource Management
I'm using a web form to collect vacation request, etc. and added a System-generated column to automatically add the Created by. The form is only available to registered Smartsheet users. Now I want to see these absences in the Resource View and to do so I need an Assigned to column. Is it possible to somehow connect the…
-
Cell value is cleared easily for a locked column before unlock
Hi, I have a calculated column field and do not want others (including myself) to override the calculation. So, I made the column as lock column. However, I was able to clear the calculation or value in the column without UNLOCKING the column. My expectation is: - others cannot change the cell values in this column; and -…
-
Can Webpack fullfill the full DevOps pipeline process for cloud native apps?
I am the only designer and developer for web/app development at my company. We want to create cloud native apps for cloud deployment and are looking at following the of the twelve factor app methodology. With very little experience in the DevOps/Jenkins Pipeline environment, I was wondering if strictly using Webpack for my…