- 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…
- 使用“由”为“分配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…
- Feedback Submitter Count
I have created a Feedback intake form and a Dashboard. In the Dashboard I would like to chart total count of submissions by each submitter name. I do not have a list of those who will submit but I know they will submit multiple entries. So I want to be able to count each of their respective entries. Lets say John submits…
- Update Schedule on Mobile.
I am new to the forum, so if I am not searching correct terms please let me know. And if there is already a thread on this directing me to it would be very helpful. I was wondering if there is any way that I can actually update a schedule (finish dates), on a mobile device while I am walking a site? I have both Android…
