-
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},โฆ
-
E-mail notifications
Hi, I have a 'Sheet' named 'Main sheet' with forms submissions arriving all the time, within the 'Main sheet' there is a field called 'Employee Department', when populated from the form this looks up the 'Project Sponsor' from a further 'Sheet' named 'Lookup' and pulls the e-mail through to the 'Main sheet' - this allโฆ
-
Average of Boxes Checked in Column
Hello all! I have a column of check boxes in which I'm trying to find the average number of boxes checked in a range. I'm trying to use the COLLECT function, w/this formula: =AVG(COLLECT([Photography Needed]2:[Photography Needed]5, [Photography Needed]2:[Photography Needed]5, 1)) When I do so, I receive the error =DIVIDEโฆ
-
Count if formulas
Hello, I have a fairly simple formula that I need assistance with. I have a 'Date completed' column (UK Date format) and a check box column, 'Test1'. I want to do a count in a separate cell for all the rows that have check boxes ticked for withinย specified month period. E.g. Count the number of test completedย inย May. Iโฆ
-
Formula results varying between today and yesterday
I have a formula pulling info from another sheet. This then feeds into a dashboard metric. The formula is a COUNTIF for anything with today's date. What is happening (and this sounds crazy....I had to get a couple of people to observe it to confirm it wasn't just me) is that at some moments in time the figure on theโฆ
-
Dropdown list Default value
Hello, I have a dropdown list of 10 values, simply aย Right First Time stat tracker. So they choose "yes" if the action on the line was done correctly, or choose one of the other 9 reasons on why it was not done correctly. Is there a way i can set the dropdown list to select "yes" as the default value? Thanks Andrew
-
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))
-
Red Flag If statement
I have an if statement that is doing what I need except when there is no value in the deadline column. I want to keep the functionality I have but make sure the flag is not red when I have no deadline set. =IF(AND(Deadline2 < TODAY(2), Completed3 = 0), 1, 0)
-
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โฆ
-
Multiple IFS for calculations
Hi, I have no problem doing this in Google Sheets but I'm not sure how to do this in Smartsheet. I have columns that contain THC and CBD content, measured in a number of different ways, including percentages, mg, percentage ranges, etc., but they're always consistent units of measurement across the row. I need to calculateโฆ