-
Is there a way to change info in a master sheet to be reflected in sub sheets?
Hi all! New to Smartsheet so please bear with me and my (maybe perhaps)silly question but one I haven't been able to find a solution to. I am using Smartsheet to compile online student registrations. My format: I have one "Master Sheet" where all of the registrations flow into. I have created "sub" sheets, and created work…
-
Update Request - Accumulated hours formula
Hi All, Currently I am setting up a tracker for tracking weekly hours spent on requests that come in via a form. I would like to set up an update request that runs every friday (until task is marked as closed) to the assigned person who will enter the amount hours they spent on the task in the week just gone. I would like…
-
Automatically display the most recent text-based comments into a dashboard
Does anyone have any guidance of how to take a response a form that could be several sentences and feed it into a dashboard preferably chronologically? I'm setting up a survey where volunteer rate their experience at an event (which fits into a chart nicely) and then can leave additional comments that I would like…
-
Emailing Forms
Is there a way to have the Form embedded in an email so the person does not have to open or click on a link. But instead can fill the form out in the email?
-
Can I use an INDEX formula to retrieve value from another INDEX Formula?
Hello, I have two similar INDEX formulas, where one works and the other one retrieves #INVALID VALUE error. They are as follows: "IF([Nov-19]188 = 0, 0, INDEX($[Jan-19]$119:$[FY50]$119, 1, [Nov-19]188))" - this one works and retrieves the value I want. "=IF([Nov-19]110 = 0, 0, INDEX($[Jan-19]$189:$[FY50]$189, 1,…
-
Form Dropdown Help
I am trying to create a form where every student is scored under the same category all at once. For instance, I have 15 students; all 15 students will be scored on 12 categories each day, with a possible score of 1-5 for each student on each category (all numbers don't have to be used, but they can be). I want the form to…
-
Conditional Logic in Smartforms (AKA Cascading Dropdowns)
We all love a Freebie? OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsheet) is the need for Conditional logic or Cascading Dropdowns when completing forms in…
-
Form Enhancement Request
We're using multiple SmartSheet forms within one sheet to record steps for various equipment to be started up, with each piece of equipment requiring responses from multiple parties and usually to be filled out over the course of time as it is being completed. We'd like to be able to show if/what was recorded previously…
-
How can I use two conditions to return a specific result in another column
I am working on creating a form for stakeholders to complete that will populate a smartsheet that we've had in place for several months. This would create efficiencies for us and help our stakeholders as well. I want to be able to do the following: When a specific selection of department is made, and the spend amount is…
-
Are logic options in forms limited to the first 10 columns in a sheet?
I have a sheet with more than 10 columns and the webform does not seem to allow me to capture columns beyond the tenth one. When setting up logic in “field settings” under the “then show the following fields” drop down only the first 10 columns are available to chose from. Am I missing something?