-
VLOOKUP on the if false of another VLOOKUP
I have a worksheet that I want to reference 5 reference sheets that contain staff members. Because of the large scale of staff members. We split them up by region. I want to create a column formula that will look up a "District ID" and return the "User" If they exist in one of the 5 reference sheets. This is my current…
-
SUMIF with cross sheet referencing
Hello all, I created a sumif formula that would reference another sheet. Copied below is my formula but it always results as "incorrect argument". I believe the problem is in the sum range (bolded in formula). Can someone please assist? Thank you, =SUMIF({SIS Quarter 1 Range 1}, [Column15]48, {SIS Quarter 1 Range 2})
-
Way to have multiple people claim an item
Hello. I have a sheet that shows available material that our workers can "claim". I have a formula that populates the Available Quantity after a number is entered into the Quantity Claimed column. I am looking for a way to have multiple people be able to claim an item if there is Available Quantity left, as well as put…
-
How to create create an audit workbook for a team of 20
Hi, Smartsheet community, I am new to smartsheet and have been tasked with a project to conduct an "as-is" process audit. at least 20 functional teams will be involved in this process. Because the teams have different functions, I'll like to give them the flexibility to duplicate all questions around each activity they…
-
Best way to carry out teams audit and monitor progress
Hi, Smartsheet community, I am new to smartsheet and have been tasked with a project to conduct an "as-is" process audit. at least 20 functional teams will be involved in this process. Because the teams have different functions, I'll like to give them the flexibility to duplicate all questions around each activity they…
-
Calculated parent % complete issue
Hello - We are using one of the templates to track a project. We track % complete at the lowest level and then use the parent rolled up % complete. We are seeing a very strange error in the parent % complete. I have attached a few examples that show the problem. You can see that the cost rolling up is not the same as the %…
-
Report with the last entry to each person's forms
Hi! I need to know how I can make a report with last entry to each "assigned to" with the row that generated into the Form. Anybody know how do it?
-
Multisite Clinical Research
Hello, I am new to smartsheets and use it for work here, in the healthcare field. I am trying to figure out the best way to utilize smartsheets to track productivity for a multisite clinical trial. I have found some articles describing how you can use other products along with smartsheets to track just single site clinical…
-
Centering Gantt chart bars vertical alignment?
Is it possible to "center" the "vertical" alignment of the bars on a Gantt chart (in a Report, but also in a Sheet)? The default seems to be that they appear at the top of their row, but I'd like them to appear in the middle so that they line up with the rest of the (vertically centered) text in the row. I feel like I've…
-
Looking for a way to auto fill the Label and Description on a form
Is there a way to quickly customize label and descriptions on forms? Like for example reference the field that contains the label and description information so it populates based on the primary value. Example I'm using the form as a voting ballot for prioritizing issues. The primary key is the Issue number then there is a…
