-
Summing VLOOKUP results
Hey community, I'm creating a way to judge submissions, where each judge has their own smartsheet (so they can see/edit their own markings but not be influenced by others). I need to be able to know (1) how many times a submission was judged, and (2) what the total score is on one single sheet. * Currently I've drafted the…
-
Auto generating mmm-yy cell
Hello, We have set up a cashflow sheet that gets graphed within a Project Dashboard. The example attached suggests that the Project commences in January 2019. Ideally, a user could enter the commencement month mmm-yy in Column 4 (Green Cell) and the adjacent cells automatically increase incrementally by one month across…
-
COUNTIFS problems
I am doing a metrics sheet to give department heads better visibility on our workflow. One of the metrics I need is how many items have been shipped, but not yet invoiced, I have a date shipped culumn (date) and an invoiced check box (boolean). Several other formulas have similar setup criteria and are also not working.…
-
Drag Down Predecessor Formula to change with rows?
Hello, So I have created predecessor formulas but when I drag them down or copy and paste them to another set of rows down below they still refer to the first rows while I want them to refer to the new rows but in the same order. For example, If on row 6 I have the formula 5FF+6D, I want to be able to copy and paste it to…
-
ISBLANK Nesting
Good Morning All, I am new to Smartsheets and would like some assistance on what I thought would be straight forward and I know I am missing something basic. So the formula in English: Is DATE 2 Blank YES - then NETDAYS between DATE 1 and TODAY in DAYS NO - the NETDAYS between DATE 1 and DATE 2 in DAYS So I thought it…
-
Email Comparison Formula Needed
Hello Community, I am looking for some help with an email IF Statement and a formula to more information, when a match is detected. I have a couple sets of 3 columns each: Email, First, Last and I need to compare Email with other sets of Emails. NOTE: The 2nd or 3rd or 4th set of Email, First, Last will not have First and…
-
Dynamic Status
A more refined and slightly more universal solution to the first posting is as follows: =IF([% Complete]18 = 0, "NOT STARTED", IF(AND([% Complete]18 > 0, [% Complete]18 < 1), " IN PROGRESS", IF([% Complete]18 = 1, "COMPLETE", IF([% Complete]18 > 1, "INVALID ENTRY", IF([% Complete]18 < 0, "INVALID ENTRY"))))) This assumes…
-
Smartsheet relational database
Hi all, Im wondering if it is possible to set up a relational database using smartsheet and cross referencing other tables (which it looks like it is), however, i'd like to also be able to query these tables for specific data. Is there a way to query linked sheets or does anyone have suggestions for tools to use in…
-
How to combine 2 Countif queries where 1 is a date in the next 30 days
Let's say I have 2 columns: Widget Colors and Order Date. I'm looking for a formula where I get the number of "red widgets" that have an order date in the next 30 days. I have tried this formula without success: =COUNTIFS({2019 Widget Reporting Range 1}, "Project") AND ( {2019 Widget Reporting Range 2}, <=TODAY(30))
-
Index Match issue
Having issues with the Index Match formula. Formula is successfully pulling information from the correct column on the referenced sheet that I want, but it is defaulting to only pulling the last row of information instead of the line that aligns with the name I would like. My formula is as follows: =INDEX({RRA Range 8},…