- Auto populating Formula Issues
I have an existing sheet with formulas to compute "netdays" left for a task, the task and variables live on the same row. That sheet has a form which allows for a user to add to the sheet a new task and assign, within the form, a start and end date. These dates are the variables that contribute to the formula. My issue is…
- Import Google Forms?
你好。新用户所以原谅我的ignorance. I'm testing the potential transition of many of my current G Suite functions over to Smart Sheet. Currently, I use a Google form to input daily information which compiles to a Google Sheet. To save time, I would rather import that Google Form rather than creating a new one in…
- Date and time stamp updated by day light savings
We have a number of Smarttsheets that are populated by web forms. The date and time stamp information that was entered prior to day light savings have now changed to reflect a "fictional time". In other words, an entry that was added at 6:00 am two weeks ago, now show a 5:00 am entry time. We need the historical…
- Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
- Save draft button on webform
Can you add a save draft button function on the webform, to allow people to have the option of completing their webform in stages, they then come back to it later if they dont have time to complete it. Thanks
- Time Tracking
I have been tasked with creating a time-tracking sheet to hopefully avoid looking elsewhere. We have various areas that work on the same project, so we need to track their work. I have started by creating a parent row (listing the name of the project) followed by the various columns of data we need to track. However - and…
- Linked Cells hindering form entries
Hi, Facing a problem with form entries on sheet with a bunch of empty linked cells. The webform entries go right to the bottom where the links end. The linked cells are important as plenty of info will be added to it in a single day and it becomes quite cumbersome to keep adding new links as we go. Is there a workaround…
- Third Party Forms Capabilities
Is there a way to use third part forms to populate smartsheets? Basically I need a form that allows for multiple row entries per form, but I know that is outside of smartsheet forms current capabilities. So if I find a third party form system that allows it, is there a way to link it up with smartsheets? Thank you, Joshua
- Form data
I created a form. Sent the form link to my email address. Received it. Populated and submitted the form. Received the confirmation email. The data on the populated, submitted form do not appear in the SmartSheet. Can anyone explain how I activate or enable the data in the form to download to the corresponding SmartSheet?
- Auto Number Columns Based on Other Column Input
Is it possible to link the auto number format to data in other columns? For instance, if the user selects a particular product type in a form (Soda, Water, Juice), can I create an auto number column format that looks like Soda-001 or Juice-001? Thanks