-
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…
-
Automatically add emails into smartsheet
Is it possible for an email to automatically be added into a smartsheet? Just like a form entry gets added, can someone send an email to a particular email address that is automatically added to a smartsheet? I saw an old post about this from a few years ago but want to know if this is something that can be done now. It…
-
Can hidden field on web form designate parent-child row status automatically?
Our Smartsheet has a client name column along with a designator column that indicates what type of work we are doing (M, S, or C). We have a web form set up for each (M, S, or C) using the hidden field so that when an "M" form is submitted, conditional formatting tells it to bold and back fill the row. Is it possible to…
-
Requesting scheduling for events that show up in calendar view
I'm using Smartsheet to request things through different processes in our organization, but one request process that is giving me headaches is requesting after hours air conditioning. We use building automation to control when air conditioning runs, and people have to request A/C if they are using a facility when the A/C…
-
Auto populate from one sheet into blank rows on another
Hi All! I searched for this, but couldn't find an answer. Maybe it doesn't exist! I'm trying to set up a new dashboard for sales reps. In one sheet I will have them fill out all of their activities. I was TRYING to get them to fill out all information on one sheet to keep things simple for them. Is there a way for me to…