-
Issue with INDEX MATCH
Hello Everyone, I have an index match formula that only works for the first row in my sheet and I have no idea why. The first row brings in the right value, all the other rows come back with #NO MATCH. There is data to be pulled back for the other rows and a VLOOKUP works. What am I missing? Thanks!!
-
Formula Help
Hello, I'm trying to create an inventory of all the items we currently have in our uniform room. The first column will have POLO Shirts USED through the year, the second column I would like to have our current stock inventory inside the room.. the third column will indicate if it was either provided to a staff member or…
-
Issue with calculating days between two dates - returns #INVALID OPERATION
Hi All, I have a column Start Date - that is formatted as a DATE column type Then I have a TENURE column - that is formatted as a TEXT/NUMBER column type In the TENURE column I am using the formula; =TODAY() - [Start Date]@row This formula used to work fine for me - but more recently when I log into the sheet it now…
-
How to include a cell value name in my automation list
To setup automation, the trigger part works perfectly fine. However, the response is to change the cell value, but the cell name doesn't appear in any of the options.
-
Formula question :)
I am trying to pull content from 2 existing sheets into a new sheet that will have additional manually editable columns. The formula that I am currently playing with isn't work, but looks like this: =IFERROR(INDEX({Type}, MATCH([EventID#]@row, {EventID}, 0)), INDEX({Event Location}, MATCH([EventID#]@row, {NOEventID}, 0))…
-
Taking Average With Grouped Values
Hi all! I am very new to Smartsheet and am trying to come up with a solution regarding taking an average of matching column values. To explain in more detail, I have "Week Of" column and a "Days to Complete" column. I would like to take the average of the "Days to Complete", but only for corresponding weeks. Essentially,…
-
If statement in parent row to delete children row?
I am working on a sheet where a task is to validate a set of data. If the data fails there is a follow up task to revise, if it passes the next task is to launch. Right now I have these all set as rows. But I wanted to see if there was a way to insert a checkbox for pass/fail and then based on whether that pass or fail…
-
simple sumif formula not working
Hello, I am doing a cross sheet formula with a SUMIF. =SUMIF({CLONE BATCH ID}, [CLONE BATCH ID]@row, {CLONE CUT QTY}) I am repeating the formula I have used in other sheets. I re-watched the formulas video and am doing everything exactly a I should. Why am I still getting a zero for my answer. It is returning the number…
-
Summarty roll-up sheet - Date error
Hello, New issue here. I am trying to do a summary roll-up of some sheet metrics. my goal is to publish this to the dashboard for ease of use. All of the metrics are based on the top cell (in green) called "Mother ID". When this number changes, so too does the associated info. One of the metrics I am trying to pull is a…
-
How to create a Sheet Summary for the last 7 days ?
I am trying to find out how to summarize (count) the number of items that have been completed in the last 7 day? but my formula is reading 0? i think there might be a syntax error =COUNTIFS(Complete:Complete, "0", Created:Created, TODAY(-7))
