-
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…
-
How to populate dropdown value list from another sheet
I have a list of employee information in one smartsheet. In another smartsheet, I'm recording events/things about employees. I'd like to have a dropdown list that have the list of employees names (from the other sheet) that I could use to select which employee this record pertains to. Help? Thanks!
-
I need to determine if a date column is blank then it returns a message
Hello, I want help with a formula to return a message that says met goal if the date is blank or did not meet if the date is populated. I tried this formula but it is not working it returns #Unparseable =IF(ISDATE([Request Intake Range 9]1:[Request Intake Range 9]22), "met goal", "did not meet") So essentially I want to…
-
Locking Values in Row
I have a column on Sheet 1 that has a formula that references a value on Sheet 2. If the value on Sheet 2 changes, obviously the cell in Sheet 1 updates automatically. I have another cell in Sheet 1 that is a dropdown. One value in the dropdown is "Completed". The values in Sheet 2 may change once a year, as we adjust…
-
COUNTIFS Issues
I am having problems getting COUNTIFS to work. I have two different formulas I am trying to set-up in different columns. I would also like cells that return as zero to change to blank. Does anyone know how I can fix my formulas and also set them up for "0" to change to blank? 1.) I need a formula that counts the amount of…
