-
Exporting Attachments to Google Drive
Smartsheet is very useful for collecting data through forms from non-users and organizing it in a database, from which automations can be run. The "generate document" automation is one I use particularly frequently. It's very helpful in making "receipts" of the most crucial information for other parties to review in a…
-
One-time pop-up Confidentiality Acknowledgement?
I use Smartsheet as a virtual data room, with each Workspace dedicated to a specific project. I will then invite different downstream colleagues to the project sheets. I would like to set-up a Confidentiality Acknowledgement statement that the colleague has to click on "Acknowledge", before being granted access to the…
-
Automation w/ nested If, Then, Else capability
I have a worksheet where every line is one of four "types". Once each line is worked and completed I move those lines to an "Archive" sheet based on their "Type". Currently I have four separate automations that move a single "type" to it's respective worksheet. The way I see current automation possibilities only allows me…
-
自動化設定でシートサマリの情報を使いたい
自動化で通知ルールを設定しようとしてます。そこで通知の宛先を、シートの列情報として保持している連絡先情報でなく、シートサマリの方で表している連絡先情報に対して設定できないでしょうか。。？
-
Moving sheet from one workspace to another
Hello, I have a general question. looking to move a SHEET from one workspace to another. That sheet has a FORM and Workflow Alerts set up. Will that disrupt my workflow and inactivate the form link? Just want to confirm what I need to do to ensure the SHEET and workflow alerts don't break. User is the same. Second question…
-
Ability to expand the size of the entry field for update requests
I've got an automation to request updates for a sheet, with one of the fields being a narrative entry. It would be helpful if I could expand the size of the box in the form for the update request, so they can better see what they are entering. As a bonus, it would also be helpful if they had some rich text attributes they…
-
Bridge examples including Javascript
Hi fellow Smartsheeters! In preparation for my session at Engage 2024, The future of workflows, I'm posting a variety of live Bridge examples to this thread. Each "block" will have a use case description, workflow layout, and (if needed) the javascript code I used. Enjoy!
-
Limit Time-slot selections
I am creating a sign-up form for an event, in which people will select a time slot to attend (1:00, 1:15, 1:30, etc.). There are 12 possible selections, and I can have a maximum of 4 people select each option. It would be wonderful if after the fourth time an option is selected it either disappears, is greyed out, or the…
-
Help Needed
Hi All, I am trying to create a formula to work out the number of days ( Helper V1 ) between the VISIT 1 and VISIT 2 days column. Any thoughts would be greatly appreciated Thanks
-
INDEX - Collect question
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…