-
Is there a way to refer to another "row" within comments/conversations? Refer to unique rows via URL
As a Smartsheet user, I want to be able to refer to a row when typing a comment so I can better give context and easily give URL's to navigate quickly to the other row. ---------------------- Use Case: I leave a comment on Row 1. Row 1 is named "Product Plan". Within the comment on Row 1, I'd like to quickly refer to row…
-
Mark an old submission
Hi, I have a sheet I created where a name and status are being inputted through a Smarthseet form. I am trying to figure out a formula to mark old submissions. Meaning if someone submits a name with the status of "Onboarding" and then submits the form again with the status "Hired", what formula can I use to mark the old…
-
Duration is incorrect and inconsistent within same sheet
What I'm trying to do: Link "start date" and "duration" from Sheet A to Sheet B What's happening: I can link the cells just fine. But the duration is being calculated differently/incorrectly. Eg I have one row with a start date of 10/4 and a duration of 5 days. Based on the sheet settings, the end date should be 10/8…
-
How can I copy data from just a few columns to another sheet?
I have a large sheet where I would like to copy the data from just 7 columns to another sheet once the data in one of the columns matches the criteria needed. For example: Copy the data from the following columns to NewSheet once the Group column says October 2021. Position Accepted, ID, FName, LName, Instructor, Email,…
-
Can I start multiple workflow in the same time and using same form?
I am tyring to make an ERP system. I created workflow to approved from the purchasing department and its department's manager with email. However, i want to add multiple items in the same time and same form to approved(in item code column). How can it possible ? I tried multi select dropdown but workflow does not work.…
-
Can an intake form populate more than just a new horizontal row in a sheet?
I have timeline templates built out in a cascading fashion (with parent and children relationships) using "workday" formulas and a holiday list. I'd like to start the timeline off with an intake form. The customer would enter the timeline type (telling smartsheet which template to pull) and then the start and end date of a…
-
How do you link certain information from a form to a sheet or report?
I am trying to link certain information from a form to another sheet. The form is a questionnaire with a Likert scale from 1-5. If the user select a 1 or 2, they are required to put in a comment. The comment is another question which shows as a column on the sheet. And lastly, the user who is filling out the form will…
-
Summary reporting with conditional formatting
Hello! I'm trying to build out a way to dynamically report on 58 state/territory sheets. Ideally, this report would have the total number of rows in the state sheet, plus the number of rows that meet two separate sets of conditions, with conditional formatting applied. I've tried doing this two ways: By using a sheet with…
-
Adding a link to specific row on a sheet
I have a sheet that has hundreds of rows and want to add an anchor type link to the top of that sheet so that I can easily go to a specific row within that sheet. Can someone help me with this?
-
Link to another sheet and conditionally output
Hello, I have one sheet that I am trying to link to and output data conditionally. There is a "LineItem to WPID" sheet where I am trying to bring in the WPIDs from my "WPID Matrix" where the LineItem header matches with the LineItem record if the Department is "CF". Is there a function I can use to bring in this data? See…
