I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an In…
I tried the AI feature for writing formulas and it gave me a slight variation of the formula below. I want it to look at the Discovery Completed column and if the box is checked then it should display…
I'm having trouble with my syntax I believe. I need to determine if Cell A AND Cell B are NOT BLANK then execute a function otherwise leave Cell C blank. The below is what I thought would work, howeve…
Hi everyone - I have 2 helper columns (Column Names: Apps scheduled for today and Apps scheduled yesterday) that is supposed to look at the create date and today's date to determine if a checkbox shou…
Hi, I am creating a multi-part IF AND formula. Basically, I'm looking at two columns: Product and State IF Product = Science, assign to Mike Foster IF Product = Mathematics AND State = certain states,…
Based on the content above for reference only, the actual sheet screenshot below. I need a formula or help with a helper sheet/workflow, to bring back one of 6 results. (above image) Tax Status Column…
I am looking to get a percent of "yes" in a column named "Yes/No" in the parent row. Example, I have a parent row with 5 child rows - 4 of the child rows have "yes" one has "No" I am looking to show t…
=COUNTIF(Created:Created, YEAR(@cell) = 2023) Generates invalid data type Created is a autogenerated date time column when the row is created. example of format - I can get a single cell from the colu…
I keep trying different variations and can't find it right: The formula that I used which is close would be =VLOOKUP([Item ID Number]@row, {Adult Sponsor List Range 1}, 3, false). Sheet 1: giving tree…
An example would be to have a "Team Sheet" that has a column for "Team Dept." and another column for "Team members" that is a contact list type. In another sheet called the "Project Sheet," We'd have …