-
Merged: Forms Set to Expire
This discussion has been merged.
-
Merging Rows from Duplicate Speakers
I have a sheet that I am using to collect COI from faculty, but our faculty often are involved in multiple activities that often leads to them inputting several COI entries. I've managed to create a duplicate checker to see which faculty members have entered their COI twice, but that doesn't necessarily solve my issue of…
-
Merged: Allow Mandatory (Required) Fields in Update Requests Triggered by Automation
This discussion has been merged.
-
How to make a Static Sheet Form for Multiple Cells?
Basically I have a questionnaire template for projects that I created that I need as a sheet to allow people to enter scoring rubrics and comments into a master sheet, but the projects need their own static sheet in each cell of the master sheet. Is there an easy way of doing this without having to create a million copies…
-
Recipients of an automated workflow notification are not receiving emails
"Hello Jake, a recipient isn't receiving alerts from Invoice Status Update" notification We created a form that feeds into a grid sheet and it has automated workflow to notify users from a cell (client emails) when criteria like "Received" and "Completed" are met Most of them work fine, but we have a group of them which…
-
Check button on form to check calculations prior to submitting the form
I am creating a end of day banking form to include all cash and eftpos transactions recorded currently in Excel. It would be great to have a Check button that checks all the calculations against a formula column to ensure it balances prior to submitting the form. If it is incorrect then it would produce an error and not…
-
Anyone have a BRD Template?
Looking for a BRD template that someone may have built and wants to share.
-
How to alter my form to fit different input options
Howdy! I'm a novice user and created this form for required reporting of upcoming courses being presented. Normally the form has been a PDF that gets emailed. Some of those who submit the information use the form, others just put the necesssary info into the body of an email, and still others send us a spreadsheet. Most…
-
Using INDEX/MATCH for a Master Sheet
Hi all, One way we use Smartsheet is to record real-time data that is then stored and referenced. I work at an aquarium so, for example, we will take daily measurements across multiple systems for things like temperature, salinity, pH, and on and on. The same parameters are tracked for all of our systems, but the thing is,…
-
Creating a summary for a workspace
I have a workspace that has a revolving set of sheets. Some of the sheets are active for the time being but are not active now. There are several cells that I would like to have on the summary , like the client name, the status of the sheet, the date expected to go live, health of the sheet. What would be the best tool to…