-
Viewing Submitted Forms
Good morning, I'm creating a form that I'd like to be able to save the responses as a PDF document. As far as I can tell, the only way to see submitted forms is through the sheet itself - not in any "document" format that could be easily saved to a DMS. Is there a method to show submitted form data in a way that would…
-
Recent Submission Formula
Hello, My goal is to create a formula that will automatically update the current status of our utility systems based on the submission of the most recent inspection form. Basically, I'm looking to create a green dot on a separate sheet if ARU1 and ARU2 are both online and both temperatures are in spec (I can provide the…
-
Strange Formula Behavior
Greetings, I am developing a solution that automatically captures a 24-hour time (as an integer value) from the generated system date/time. The goal is to allow users to use a form on a tablet to enter a few fields of information into three sheets. My solution converts the times in each sheet correctly: Above is a portion…
-
How to use index/match on multiselect dropdown list?
I am working on launching a global hiring form that uses this formula: =IFERROR(IF(Country@row = INDEX({Approved Seats Country}, MATCH([Unique Seat Code]@row, {Approved Seats Unique Seat Code}, 0)), 0, 1), 2) Basically this formula returns the number "1" by searching for the name of the country in the source sheet…
-
Mapping out the logic on a form
I have a form that uses logic in some of the fields and I need to map it all out for others to review and make sure I'm not missing anything. The form is fairly long. Is there a template for a workflow of some sort that might work? I need it to show what happens when the logi is met for a field, and what the smartsheet…
-
Way to have multiple people claim an item
Hello. I have a sheet that shows available material that our workers can "claim". I have a formula that populates the Available Quantity after a number is entered into the Quantity Claimed column. I am looking for a way to have multiple people be able to claim an item if there is Available Quantity left, as well as put…
-
Rounding
@Genevieve P. I hope you are well sorry to as again, please could i have some assistance on the below question. I want to type in 5979.100258 in a cell, for example, and it's rounding up to 5979.10026 - which I don't want. How can I get my numbers to remain exact? sorry to direct this one to directly.
-
Best way to carry out teams audit and monitor progress
Hi, Smartsheet community, I am new to smartsheet and have been tasked with a project to conduct an "as-is" process audit. at least 20 functional teams will be involved in this process. Because the teams have different functions, I'll like to give them the flexibility to duplicate all questions around each activity they…
-
Report with the last entry to each person's forms
Hi! I need to know how I can make a report with last entry to each "assigned to" with the row that generated into the Form. Anybody know how do it?
-
Form Email to only show what was filled out
Lets say I have a form that has 200 questions on it. The person who is filling it out, only answers 50 of those questions and attaches some documents. The email alert that I get automatically shows me all 200 fields and i have to scroll to see which ones they answered vs they didnt. How can I make the email only send what…