-
Convert a row attachment from jpeg to pdf
We are putting together a credit card receipt tracker in smartsheets. I have a simple form that asks for 4 fields of information and then a document upload. The employee would fill out the form and snap a picture of the receipt to upload to the form. The file comes through as a jpeg using an iphone and selecting the take…
-
Creating a formula that references a static cell?
Hello, I have a form that is submitted to one of my sheets daily. Currently, new entries populate at the top of the sheet. I am using a formula that always needs to reference the top row, or newest entry. Is there a way to accomplish this? Currently, if a new entry is submitted, the formula changes to tracking row 2…
-
Email automation with attachments?
Hi all- Wondering whether any of you have worked with automations involving sending emails with attachments. I am working on improving our system for issuing travel reimbursements post-conference (we have to use a specific Excel form for now sadly), and we are currently using Smartsheet/Generate Document to generate…
-
Can forms return the label and help text in email to person entering the form?
I have a created a desk assessment and in the form provided some assistance options to better the evaluation. Example … Question is longer than the column header so I've put it in the Label as this … Is the Keyboard separate from the screen? Response options are Yes / No / N/A, but in the Help text - I've added Further…
-
How to add additional information after a form is submitted?
We use forms to create project requests, and we know each form is submitted and creates a new row in the underlying sheet. We have 6 unique forms tied to one "project type" sheet (x3 project types). The forms are super intricate and logical, and the sheet has a ton of automations and workflows to it. Our executives want to…
-
Capabilities of Global Updates
Could we use Global Updates the make the following changes to blueprint sheets: Add shared filters to the sheets Add Forms to the sheets Also, can we provision a blueprint sheet including shared filters and/or its own form (not from specific link)?
-
Autopopulating Dates Based on 2 Fields
I'm struggling. I have a workflow to auto-populate the created date. I have another column that determines the type and length of review requested (3 days, 6 days, or 12 days). I would like to auto-populate to a specific submission date Mondays at Noon to be discussed at a recurring meeting on Wednesdays, so it would be…
-
How to apply cell formula to new rows added by form.
I have a cell formula to apply to the row 1.. I need new form entries added to top row to automatically apply. The form entries are the amount of dollars or change turned in to get total amounts by count. I can not make it a column formula. please advise. I tried using Absolute ($) but it changes row # with every new entry.
-
Can you set up logic in forms that have a start date?
Working on a project that I need to add form logic to but don't want it to start for a week? Is there a way to have a start date in the future OR will it only start once added?
-
Form not using logic despite being set up.
Hi, I have set up a form which will be filled out whenever a machine encounters a downtime period and have set up certain logic to show questions depending on the previous answer. For example answering 'Machine' with either "EMZ 3612" or "EMZ 3610" will show the 'EMZ Downtime Type' question and so on for other machines. I…
