-
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…
-
How can we make GIS available to Land Agents without GIS experience?
In the charming town of Williamsport, Pennsylvania, between 2010 and 2012, a knock on the door carried an extraordinary weight of expectation. During this era, as America's real estate landscape slowly mended from a severe recession, families across the nation watched helplessly as their financial security and dreams…
-
Automations Between Sheets Without Formulas
I'd love to be able to change cell values in a sheet or copy/move a row of one sheet based on the value in another sheet. You can technically set up a formula to change the cell value using some kind of lookup but I'd like it to be a one time thing and then have the user edit the cell manually after. The example I have is…