-
Updating Rows on different sheet assigned to a user?
Dear All,new here, apologies if this has been discussed before, couldn't find anything. A question regarding the following scenario: Imagine a sheet (sheet 1) in which a user/department ads their requests assigning a task to a specific user/owner. Is it possible to update the sheet of the owner only when a task is assigned…
-
Nested Formulas
I am attempting to use the nesting formulas to auto generate text showing the status of a project step that is co-dependent on several previous steps, but only when the previous steps have been selected. For instance,we have an "Assigned" column which is just a check box, a column which indicates if that task is complete…
-
Circular / Blocked Reference (Vlookup)
I have a problem with 2 sheets reading each other’s data through a VLOOKUP. The same problem was posted on May 30, 2018 by scott.barrett. Obviously it is not solved. My sheets also work perfectly for periods of time, and then start returning #circular or #blocked data without any changes to the sheets in almost every 2…
-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
Wrapping cell text in reports
Hello all, I'm trying to build a Sight with several reports and noticed that I do not appear to have the ability to wrap the text in a report, is this true? It is making the layout of the sight much more difficult since a few of the task names and comments/updates make the report very wide. Plus it is hard to know how long…
-
At Risk Report with parent and only some select rows
Can someone please assist with reporting at risk line items? I have parent/child hierarchy and want to only report those parents that are over budget and only the line items under that parent that have fees greater than 0.
-
Issue setting up report for name off Contact List that has no hits yet
Is there no way to create a report pulling off someone in a column's contact list without actually having an instance of that contact being mentioned in the source sheet? For example, sheet ABC has an "Assigned To" contact list column that includes "Bob". However, Bob does not actually have any tasks assigned to him yet. I…
-
Formula to track % complete of a fabircation component in a row
Good evening, I will try and explain this without messing up * We are using smartsheet to track fabrication of product * each row is an item we fabricate * each item has a budgeted amount of time per task designated in a column * they are python, fit up , weld, unload, and admin * the sum of alloted time is *…
-
Master Roll Up Sheet and Reports
Hi there. I'm still rather new to using Smartsheet and am being tasked with really thinking outside the box to creatively build views and reports with Smartsheet. I am currently working on a project where we have 8 auditors (with 8 separate sheets of their own). Each of the sheets has categories and subcategories of the…
-
Symbols not showing in reports
I have a large Smartsheet grid that contains important information against a list of devices. Some of this information shows the status of some testing and is displayed as symbols. Rather than share the whole sheet with staff, I would rather share a selected few columns in a report. However, symbols & dropdowns do not…