-
Apostrophes being added in front of numbers and column property changes to dropdown (data shuttle)
When I use Data Shuttle and I upload the source to the target, it is changing column property from text/number to a dropdown and adds an apostrophe before the number. I have 8 "discount" columns per sheet, but it only disturbs some of them. If I need to perform some calculations using those numbers, I can't. I'm not sure…
-
Multiple approvers simultaneously
I am trying to create a workflow that allows form responses to be sent to multiple people to approve at the same time. Currently, how I have it set up, there is only one approval cell available, which means that only one person can truly approve the form responses. I am wondering if there's a way to add multiple cell boxes…
-
Filters in reports
Is it possible to filter in a row report for a field which is in the sheet summary report? I mean I need to create a row report, but also need to have a visualization based on a single field which I only have in the sheet summary report. This way it would clearly be a way to get a filter on a list of sheets to put in my…
-
Coping currency values from excel into smartsheet
Hi guys I have to copy some currency values from Excel to smartsheet (South African Rand) In Excel it is displayed as R 14 953,60 for example and when I copy it over, it only takes it as text, and then I have to remove the R, the space separator and replace the "," with a "." before it recognizes it as a number in…
-
Best way to do communication in Smartsheet - current @texting
My smartsheet is large and growing. Managing many aspects of a large construction project. right now I micromanage in that I ask questions to specific tasks The is broken up via 26 construction divisions Each Division has multiple sections And Each section has many items to track I @comment on how a tasks impacts the…
-
Auto number field
Hello, I added an auto-number field to my form, but it's not being captured on the sheet. I don't know if I added it to the form correctly, because I can't see it in the form. However, when I try to add another auto-number field, it's grayed out, so I think it's there? Can someone please help? How do I remove the…
-
Using forms and multiple rows
Hello, I have created a form for my team to enter data to populate on a master sheet. We will have multiple part#'s and QTY's per request, however, I cannot find a way to have forms split those into separate rows. Is there a way to have a form submission separate by line in the form to a separate row in the sheet?
-
Combining rows with like names
We have a sheet set up with forms to allow for participants of a contest to #1 register for the contest, then #2 go to the second form to update their progress in the contest. Is there a way to combine rows when a someone submits the same name or email address, for easier tracking? Something that is automated to create…
-
Sending an update request
When sending an update request, is there a way to only include two or three columns from the row - instead of the whole row with all columns? I hope this makes sense!
-
How to cascade the same grouping of rows multiple times for device management in a form
If I have a row that says "how many devices do you have?" And a user inputs 6 (for example). I would want the form to present the same grouping of three rows (serial number, location, owner), six times. That way each device has a unique place to document these discrete items and they file back to the same column in the…