-
Smartsheets Budget Forecasting
Hello, I am trying to create a custom sheet. It would be a calendar with a nested daily budget. For each day of the week we would be able to update the expenses or add budget forecasting. It should also show the running monthly and yearly total.
-
Allow ISO 8601 Date format for dates (YYYY-MM-DD hh:mm:ss)
ISO 8601 is an international data standard and a part of two national standards in the United States. "The standard provides a well-defined, unambiguous method of representing calendar dates and times in worldwide communications, especially to avoid misinterpreting numeric dates and times when such data is transferred…
-
Add Cell Data in a Custom Form URL
Hi. I've created a form and want to create QR codes that, when scanned, pre-fills certain data (a session title, and speaker name). The Session Title and speaker name are in a different table (TABLE1) for which the form feeds (TABLE2). The URL will ultimately resemble:…
-
Question about data collection via form
Hello, I have a logic in the form that will request to fill some info based on the dept, e.g., if they select 4 depts, the form will show 4 sections of info to fill. The issue is each dept needs different info. The max # of dept is 20, which is a lot if they selected all of them. I wonder what I can do to make the data…
-
Germany - phone number validation in forms - 2 extra digits?
I'm having German customers complain that the phone number validation in forms will not accept their numbers - because it seems to be missing 2 digits. Here's a generic example: +49 171 1234567 formatting rules/ examples coming from this site: https://www.simplegermany.com/german-phone-number/ Germany: Anyone who's more…
-
Document Builder - Generated Document to pdf. or word file
Hello Smartsheet Community, My team and I have identified Document Builder as an applicable tool to use for how we write up Standard Operating Procedures. We have built out a form that captures the high-level information, which then runs an automation using the submission data to generate a template for the author to then…
-
Need help with Form capabilities!
I am trying to create a temporary process for employees to submit time and expenses. There is a Entry Type Field that specifies which fields are displayed based on if it's a time or expense. For Time - I have logic set up that based on the date a new field will appear labeled as which day of the week corresponds to the…
-
How to Design My Smartsheet App
I work for a Hospital and I am creating an application to track employee health details such as vaccinations, annual health reviews, health exams, etc. For example, employees are required to get a flu shot each year or a waiver. Employees also have to take certain tests when hired such as a chicken pox test and a color…
-
Did smartsheets remove the "file upload" function from forms?
Just yesterday I had a file upload field on one of my smartsheet forms. Today, it looks like that functionality is missing when I went to add another. Any knowledge on this? Maybe it was part of an update or maybe I'm just missing something.
-
Can you reload a form with fields prepopulated from the previous form submission?
We have a form that allows users to submit ideas for an upcoming conference. We want to allow them to submit as many different ideas as they'd like, each one on a separate row, so we have the form reloaded after each submission. We'd like to prepopulate a couple of fields on the reloaded form with data from the preceding…
