-
Can you cell-link within the same sheet?
My team is tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled "Refer To" and then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a…
-
Automation Workflow Asssistance - Trigger based off Task's due date
Hello, Is there a way to sent an automation reminder to be triggered on my project plan for a task when another task's due date is 3 weeks out. For example, I have task A, task B and task C. Task B and Task C need to be completed before Task A can be completed. I am wanting to create an automation to notify the assignee…
-
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…