-
Form Response getting captured from row 49 not from from top row
I have created a smartsheet form. While testing it, once I fill up the form, it's response is getting captured from row 49 in my smartsheet (I want this to be captured from row1 itself and other response on row 2 and so on...), I have looked for solutions on the community but could not find anything related to it. Can…
-
Move Row/Copy Row Automation flowchart
Hi Smartsheet, I'd like to have a high-level Smartsheet view that shows, in a visual, the "Move Row" and "Copy Row" automations from one sheet to another. This would be extremely handy when communicating to management or onboarding new employees to existing Smartsheet processes. Additionally links directly to the sheet on…
-
Reply box is collapsing / disappearing when replying with '@' character
My reply collpase after the Date@row - it just collapse and I am having hard time adding anything at the end.
-
Counting name and flag in another sheet
Hi, I have a sheet that lists Muppets and a traffic light flag. In a sheet I'll use for dashboard matrix info, I want to count how many times each Muppet has each colour of flag. Each Muppet is listed in a column called Metric. My countifs formula is returning a value of 0 when I know that Ms Piggy has one red flag (for…
-
Traffic Light based on multiple-select drop-down in next column
Hi, I would like to automate my traffic light (here called Overall Assessment) based on the count of options selected in Potential Impediments. It is possible to select 0-5 items at any one time. Would the best option be to have a hidden column that counts the selection and use that as a reference point for the traffic…
-
Sharing form link without providing edit or read-only access to underlying Smartsheet
Hello, If I create a form that I want other departments to fill out when submitting an analysis request to my team, is there a way to make it so they can't see the underlying/source sheet? The sheet the form is tied to contains all of our project data and doesn't need to be visible to those outside our department. Thanks.
-
Bridge: Google Translate with support for array translation
Hi, I was doing work for one of our clients where I hit a system / feature limit: Task: Translate 500 rows of text in a sheet into another language and write back in another column within the same sheet. Limitation: Google Translate module can't accept an array as input. For this reason, the translation task has to be…
-
Repeated Task
Hello all you wonderful SmartSheet users I am trying to find a way to represent a repeated task and the associated information (Start /finish Dates, Status, % complete) from the first time this task is completed. i.e. I have a drawing and its associated sub tasks. This drawing is a sub-task in a later drawing. As such, I…
-
Why is the Start Date inconsistent?
The START date on Row 813 is different in these two examples. Why? The image labeled "Correct" has Row 813's predecessor pointing to a row that has no predecessor. As such, Row 813's START date is one day later than the FINISH date of its predecessor. The date on Row 813 shows (3/12/24 shown in yellow). This seems correct.…
-
Booking System in Smartsheets Forms
Hello everyone, I'm a relatively new user to Smartsheets and this is my first post. I have a question please about Smartsheets forms. I work as a videographer and I'm trying to write a form that allows people to hire out equipment (say for the sake of argument we only have one equipment type at the moment at that is…
