-
how can I add on the roll up table my contact list of mangers so that the formula work
i have tried adding the email - the name but it doesn't work ! this is the formula I have used and referenced the assigned to and status column
-
Moving Comments Between Sheets
I am looking to find a method to copy select columns in a row along with the row comments from one sheet to another. Methods that I have tried and will not work in this scenario: Copying the entire row from Sheet A to Sheet B (This brings over all columns and I am only looking to copy over select columns) Using helper…
-
Auto-Sorting sheet hacks
Hey guys! I've long been searching for a way to make one specific sheet auto-sort, without having to create individual reports. I know this has been a requested feature for ages and that it's in the works. I was curious if anyone has come up with any clever workarounds that can be used while we're all anxiously waiting? I…
-
Only Part of my formula is not working and I can't figure out why
I created the formula below and it is working for the section that says "Validations - Issue Validations" and "Validations - Regulatory Issue" part and I can't figure out why =IF([Risk Activity]@row = "Control Testing", IF([Actual Cycle Time]@row <= 75, "Green", IF([Actual Cycle Time]@row <= 90, "Yellow", "Red")), IF([Risk…
-
Group Rows Automation based on unique column ID
I am looking if there is a way to group rows that share a unique cell (i.e. Quote #) into one parent dropdown. I am wondering as a workaround due to the fact that the "Copy a row" automation from one sheet to another does not update the existing row but rather adds another row for the same quote ID # in this case. We are…
-
Report data not visible to those with access
Anyone else experiencing this just recently? I have a handful of people not able to see Report data (some or all - depends on the report and it's happening on a ton of them) that they should be able to see and have access to? It's not an access/ sharing permission issue. There is not a current user filter on the Report.…
-
Best Practice for Multiple Sheets with Column Formulas
On my Smartsheet I have multiple sheets. Requests come in on the Request sheet, then move to an Approved, Hold, or Rejected sheet. I'm wondering if some of the column formula's I have should be removed from the all but the Request sheet. Those formula's are meant to provide guidance on what action should occur with a…
-
Several tests on the Same Object need help with Report and Layout
I have an experiment where I test object a, b, c, d. The variables (columns) will be height, weight, fill with fluid etc. however I might have changes for the test objects and re-run the experiment where I poke a hole in (a) and therefore need it to be tested again. How do I create a report that shows all tests a-d and…
-
Data Shuttle - Delete Rows No Longer In The Source File
I am trying to use Smartsheet and Data Shuttle to automate an open order report that we use. Part of the reason that we're trying to switch it over to Smartsheet is that we want it to be a living document, so that our buyers can write their notes for each order and see what is happening with other buyers orders should they…
-
Need help with a couple Formulas for On hold and Certain Counts
First formula - In a sheet, in sheet summary I need a formula to count the instances certain Project Channels show up. There are three that will need to be counted. For now let's just call them Channel 1, Channel 2 and Channel 3. They are a dropdown column. Second formula - same thing-same sheet and sheet summary formula.…