-
Is there a way to use a CountIF formula that would ignore hidden rows/cells?
Hello, I am am trying to create a summary report that would count the number of "complete", "not started", and "In Progress" with only using the rows/cells that are filtered. I do not need to count the rows/cells that are hidden but when I use the COUNTIF function, it would also count the hidden rows/cells. Thank you.
-
Field "position" in view to stay the same
Hi guys, I'm a new Smartsheet partner trying to develop a custom solution for a client. So the client requests Dashboard with up to date leaderboard on it. I've made the leaderboard and connected it to other data so it calculates victories, losses, goal diff and everything, and as far as i understand, best way to sort the…
-
IF(CONTAINS) statement applied to cells with multiple entries; desire mulitple output
I am writing a formula to read a cell that contains city names, and I want to output a general region/area. In order to do this, I have written an "IF" formula that uses the "CONTAINS" function so it doesn't have to be an exact match. But I also want the output to be dynamic... so if the cell contains say Paris and Hong…
-
Sheet Summary Formula Needed: Sum all numbers in a column for rows which match a criteria
Hi, I am looking for help writing a sheet summary formula that will sum all numbers in Column B for all rows matching a criteria in Column A. I have a sheet that tracks transactions by salesperson. Each row is a transaction. I have column that contains the commission for the salesperson for each transaction. In the sheet…
-
Using IF, OR Formula to Return a Value
I have a sheet that I want to return a value of 1 or 0 if EITHER of two possible drop-down menu items are selected. This formula I tried is returning an Incorrect Argument Set: =IF([Safety Plan Status]2 = "Accepted", 1, 0, IF(OR([Safety Plan Status]2 = "N/A - No Onsite Labor", 1, 0))) I am sure it is in my syntax…
-
How can I identify which form was used to submit data
I'm using 2 different forms to create new rows on a sheet. I would like to know which form was used to enter the data. Is there a way to do this? I have tried using a URL query string to specify default values, but I don't know how to hide it form view.
-
Is there a way to trigger a workflow if an end date changes by 5 or more days?
I'm looking to create an automated workflow to copy any row from a project plan that has the end date changed by 5 or more days. Is there a formula I can include in the automated workflow to accomplish this?
-
Beyond Vlookup ... Report?
Hi All, I'm in a bit of a situation and I'm looking for ideas... I have a .csv that I import into smartsheet. It is quite a big file that contains a lot of data. I need to copy some of this data in different sheet depending on a customer name. So to simplify (big time) let's say the below is my table I have different…
-
Vlookup range not updating with form submissions
I have a sheet with a list of employees that references form responses on a different sheet, and via vlookup function pulls in the date a form was submitted (to track who has submitted the form, and who as not yet done so). The problem I'm having is the vlookup range automatically limits itself to the forms already…
-
Imported Data not Matching Up to Columns in Smartsheet
Hi. I have created a smartsheet. I have also created a form, that will contain excel based data to be imported into the SS. Here are the steps I've taken: *from SS, click on File>Import>Import Excel>Select the file>Continue>see a Message Box with Column Headers. I click on the row that contains Column headers>Import>Form…