Sheets
Discussion List
- Hi there! I've been stumped on trying to make the correct formula for my situation. Any help is greatly appreciated! In one sheet (Data Collection sheet) I have a column for Sample ID and a column for…
- I was reading this help and it has some parts I need and noticed it referenced a sheet that no longer exists. https://community.smartsheet.com/discussion/69259/formula-to-pull-data-from-one-column-and…
- Hello, I have a sheet where one of the columns is a dropdown with multiple values in each cell; need to know if it's possible to copy a specific value from those in the cell to another smartsheet with…
- I have this formula: =IF(ISBLANK(Location@row), "", INDEX({Location_code_helper Range 1}, MATCH(Location@row, {Location_code_helper Range 2}, 0)) + "-" + RIGHT(Year@row, 2) + "-" + COUNTIFS(Location$1…
- Hello All, We will have one project that will have multiple locations (that has other information such as num of people, city, country, name etc...). Since we have one intake sheet and as the new proj…
- I think with the extreme power of reporting on smartsheets and being able to get all the data you want in one place from multiple sheets, you should be able to link the report to create a graph rather…
Smartsheets issue with Start and End TIMES - is there a way to utilize MS project to feed that info?
Hi! I have been using Smartsheets for the past 4 years, and I love this product; however, one downfall is there is no ability to have an auto updated Start and End TIMES down to the minute (not dates)…- Is it possible to add rows to a sheet through a report? Is a certain permission level required for this? Thanks!
- Hi, I have a list of names that were entered to the sheet more than once (but a different value in other columns). I have a helper column to identify which are the duplicates, but is there a way to sh…
- I have rows copying over to a new sheet whenever column C is a certain name the box in column J is checked. Source sheet: Destination sheet: I would like a formula to automatically update the symbol i…
