-
Sum of Values Between Two Dates
Hi All! I am trying to write a formula that add up the total "crew size" required between two dates. I've created a metric sheet to hold the formula. See screenshot of parent sheet below. Formula: =SUMIFS({Shop Overall Schedule Range 1}, {Shop Overall Schedule Range 2}, >=DATE(2023, 9, 1), {Shop Overall Schedule Range 3},…
-
INDEX (COLLECT) Formula returning #INVALID VALUE Error
I am trying to use INDEX COLLECT to pull data out of a specific column from another sheet based one three criteria. My formula is: =INDEX(COLLECT({Site Visit Intake - DOM Review %}, {Site Intake FDC-FW}, FW@row, {Site Visit Intake - DC}, DC@row, {Site Visit Intake - Metric}, [Metric Being Evaluated]@row),1) I keep getting…
-
Combined Multiple IF CONTAINS Functions
Hi, I have the following formula =IF(CONTAINS([Column A]@row, {Sheet A Range 1}), "Sheet A", IF(CONTAINS([Column A]@row, {Sheet B Range 1}), "Sheet B") Now I want to add if both sheets contain [Column A]@row, result: "Sheets A and B", How do I add this last part in addition to my current formula? Any help is appreciated,…
-
Way to get average number of submissions per day?
Working on an intake form with hundreds of responses and I wanted to know if there was a formula to calculate the average amount of responses per day. Thanks!
-
is there a column number function for vlookup?
VLOOKUP requires a number for the column position in the table reference. But I have users who have been known to insert columns into the referenced sheet to the left of the needed column, throwing off the returned value. Is there any function I could nest inside the vlookup where I could provide the column *name* and…
-
formula for status column using symbols based on end and target dates
Hello, I would like the status column (set to red and green, ball symbols) to automatically update based on task due today vs target date. Here is what I would like: If end date is not past target date then status is green If end date is past target date then status is red Could someone help with the formula? Thank you in…
-
I need a formula to return the most common value in a column.
I need your help to create a formula to return the most common value seen in a column. I have a dynamic list of Names and I want to display the name that appears the most often in a Summary field. Mental block, sorry! I've seen very similar posts but nothing has worked. From this example, I want Joe to be displayed.
-
Formula to create a round number
Hi - I have this current formula in my summary sheet, what do I need to add to it to create a round number? =([Task Status Complete]# / [Total Tasks]#) * 100 Thanks!
-
VLOOKUP WITH MULTIPLE SHEETS
Hi! I´m trying to use VLOOKUP with IFERROR formula to find an information in more than one sheet, but it´s not working... The formula I´ve been trying: =IFERROR(VLOOKUP([SV / OS]@row;{Base Transações Intervalo 1};6;0),(VLOOKUP([SV / OS]@row;{Base Transações 02 Intervalo 1};6;0))) It always return #UNPARSEABLE I couldn´t…
-
Inserting Unique IDs across multiple sheets
Hello, I am very new to Smartsheets and I'm really struggling with creating unique IDs across multiple sheets. I have 3 separate data sets split across different regions. I can't use regional unique IDs. I need one sequential, unique ID across the 3 datasets (i.e. a national ID). It has been advised that one way to achieve…
