-
Help With Formula on Multi-Select Column
Hi, I want to take demographic data from 11 columns and translate that to a multi-select column. I want my column "Original Demo Contains" to change dependent on the data in the 11 columns following it. If the value of any of the 11 "Original Demo - Caucasian", "Original Demo - African Amerian", etc columns is greater than…
-
Averaging Health Status for Parent Rows based on Average of Children Rows in RYG including BLUE
Hi- I'm trying to average children rows with RYG and Blue status where: Red If Red is greater than Yellow If Red is greater than Green Yellow If Yellow is greater than or equal to Red If Yellow is greater than or equal to Green Green If Green is greater than Red If Green is greater than Yellow Blue If only status is Blue…
-
Appointment Number Generation
I am building a Project Management system to deal with a high flow of scheduling. Currently I have the system built using the auto number column type, however when it came to creating a copy of the row I quickly found that the system will not update that value when it is passed out to a separate grid and cleared of…
-
Working with data betwen two sheets and mutliple columns
Good Morning All, I am having with an issue matchhing data between two sheets based on certain criteria. 1st sheet is a list of form responses. I have a name of requestor column. I need to complete two objectives based on this requestor. See if their name exists in one of two columns on another sheet. 2 if their name…
-
Formula for counting publications in a calendar year
Hi, Here is a background on what my ask is: We track publications on Smartsheets and the publication activity column has the following drop-down options: Journal Article Meeting/ Conference Abstract/ Poster Book chapter Non-authorship contributions to publications (acknowledgement) Non-scientific presentation (podium/…
-
COUNTIFs for multiselect drop downs
Hello, I have a set of form responses where 350 colleagues have given their job level, and provided their 5 personal goals (in separate columns), and which of our organisational targets their goal aligns to. They have selected the alignment to our organisational targets from a multiselect dropdown, and some people's goals…
-
Counifs Dates from 3 columns
I have searched the threads and tried so may formula options and none worked...hoping someone can help me figure out why my formula is not counting the number of text occurances in three different cells in my sheet Here is my sheet: and in my Total Minor field I want to show the number of occurrences of the word "Minor" in…
-
How can I pull in certain data from the last 30 days?
I'm trying to pull in certain data points from the last 30 days to show metrics. I already have a calculation sheet that pull in the entirety of our tracker and keeps count of what we're looking at, but now we want to show it more granularly. Essentially, I want to be able to say, "In the last 30 days, there were X number…
-
Pulling Data from Column in Another Sheet
I am trying to pull data from a date column in another sheet - per location, month and year. I have tried the below formula with no success: =IF({Center Name}, $[Center Name]@row, {Final Walk-Through Date}, MONTH(@cell) = $[Month #]@row, {Final Walk-Through Date}, YEAR(@cell) = $Year@row, COLLECT({Last Inspection Date}))…
-
If Blank
I apologize in advance as I know this has been asked and solved multiple times but I can't seem to figure it out. I have totaled (sum) of numerous rows that I would like to average, and to do so I need to remove the zeros. I am struggling with the "If" formula. Any help would be appreciated.