-
Use Formula to Assign Dropdown Selection in Column
I would like to have the column titled Alert Level return a symbol from the dropdown menu based on the number of selections in the Alert column. I'd like the symbol to be green if there the Alert column for that row is blank. Blue if there is 1 item in the Alert column, Yellow is 2 items and Red if there are 3 or more. Is…
-
How to Pre-Populate a field in a form with a unique ID?
Hello Community, I am asking for your help today figuring out a challenge I am currently facing. We are trying to pre-populate the "Work Order ID" field in the form because it is often overlooked or entered incorrectly. We have been trying to figure it out but it is hard because you cannot have a column formula field in…
-
SUMIFS Returning Zero?
I am trying to sum all hours that meet a certain criteria (match the lookup column/project ID). My Formula: =SUMIF({0 | Affiliate TESS HOURS}, [LOOKUP COLUMN]@row, {0 | Affiliate TESS Lookup}) {0 | Affiliate TESS HOURS} --> references "Entered Hours" {0 | Affiliate TESS Lookup} --> References "Lookup Column" Formula is in…
-
Countif formula for multiple items in parent row
Here is my table: In the Gender ID column I'd like to see a count of M and F in both the 1st and 2nd hierarchy rows. For example, in first row, K, it should end with M-2 and F-0 and the same in the 2nd row, Frizzle. For the row, 4, it should return M-3 and F-3, but under row, Dumbledore showing M-2, F-1 and Yoda M-1, F-2.…
-
Form Automation
Hi, My vision is, that when a form is submitted, it is placed into the appropriate bucket based on the person assigned. For example, a new task is submitted for Austin via a form, when submitted, it is placed in row 1. I would like it to move into Austin's task area automatically. Is this possible?
-
Problems with using formula to count items in drop down list
Hi I am hoping you can help me out here. I am trying to create a pie chart on a dashboard to display the proportion of technology types that are being serviced. This is a drop-down list with 5 different values. I read it is easiest to count the values individually in the Sheet Summary and then use that to create the chart…
-
Formula to make it to check the checkbox in another sheet.
Hi all Hope you can help me. i'm trying to make a formular that can help me check off the checkbox in another sheet. So its going to be somekind of formular that looks into another cell and if it is checked off it is going to checkoff in that sheet as well. So 1. sheet is the Intake sheet. - The 2. sheet is the tasklist.…
-
Formula to calculate day from a series of dates and times
Hi All, This might be a long shot but is there a formula to search and find a multiple entries of a job number then look for the date column and calculate the series of dates for start and finish time and also include the in and out times to create a Gantt chart? This is all data that will be entered into a separate…
-
Auto Number Column is Being Copied Over From New Rows
I have a row ID setup with auto numbering on a totals sheets that contains all the copied rows from multiple projects. When the copied rows are inputted into the total sheets (using automation) the row ID is then updated with the row ID from the other sheets. I use this auto number field to identify duplicate rows (and in…
-
INDEX(COLLECT( )) where some rows are blank
Hello Community! I'm missing something here, but I'm not sure what. In this sheet I need to pull a date from a master sheet. The formula works perfectly for the first two organizations, but then the next one it pulls is simply the next cell in the date column in the master that isn't blank. It isn't the date that goes with…
