-
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))
-
Forms that need to incorporate multiple line entries
We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is filled in and the 'save' button pressed Are we able to set up a Smartsheet form to…
-
Specific cell reference in update request text
Hello! My examples are in French, but as SS is the same, you should understand with the visuals. I used a template as a base for my project management office. In this example, we create a folder with the project name, but all the subfolders remain “generic” in order for the links between them to continue working if we make…
-
Uncheck box when another cell is not empty
Hi everyone, hoping for some help with a particular workflow I have been struggling with. The short story is I'm hoping for a formula that unchecks a field when another cell is not empty. The longer story is: We use a checkbox that triggers a request for clarification from our customer. It sends them a form, with a cell…
-
tryin to if function with OR and AND
Hi All, If there is a date in 'date found' column and date in 'Date collected' column, Column7=Collected if there is a date in 'date found' column but no date 'Date collected' column, column 7=Uncollected if the 'Date found' column is blank, column7=blank Can anyone please try help @Genevieve P. @Paul Newcome can you…