-
Database of information from one sheet to another
Hi all, I have a sheet that is a "database" of about 400 records. I want other users to be able to input one column of that sheet (Media Company Dropdown) in a form or other sheet and for the next seven columns to autopopulate. Is this possible? Would VLOOKUP be a solution? I've read a few forum posts that said that…
-
Collect Criteria not being filtered
My nested COLLECT function's Criteria does not appear to be working because the formula runs into errors when a duplicate date is found before the actual date that should be being pulled. =INDEX([Baseline Variance]5:[Baseline Variance]128, MATCH(MAX(COLLECT([Task Complete Actual]5:[Task Complete Actual]128, [Milestone Type…
-
Use triggers from Smartsheet?
Working on a new workflow. Today's workflow is manual and based on emails. I'd like to use the webform to collect the required data (done) and then, based on specific conditions in the sheet fields trigger actions in other system - from generating email to open a service ticket etc. I watched the movie of the docusign -…
-
Find Value in List in Cell
I have two sheets---one with a list of program that includes rows with a cell that has a list of course prefixes. EXAMPLE: ROW 1--->Doe, John | doej@xx.com | BUS,CUL,MGT ROW 2--->Smith, Elle | smithe@xx.com | HOS,SUS Each row has three columns: name, e-mail address, and course code prefixes. On the second sheet, I want to…
-
Share Data Across Two Sheets
I have a master sheet with data for a list of courses to be developed in the new term. I am working with a vendor on some of those course. Let's say 10 of the 15 courses. The sheet also has a column indicating the status of the development. I do not want the vendor to edit or view this sheet. Instead, my thought was to…
-
New sheets created in one browser tab not available in other browser tabs.
When I create a new sheet in a different browser tab - you know, because we can't open multiple tabs anymore - the sheet is not available in the other tabs. I went out of the folder and back in to give it the opportunity to update, but it didn't. It does not see like the browser tabs are working very well. Maybe we should…
-
Reference a Cell in another Sheet in a Formula?
Howdy! I'd like to count the number of occurances of a specific value in a column on another sheet. It works great this way, but within the same sheet: =COUNTIF([Column4]17:[Column4]26, "Red") Is there a way to select a range of cells on another sheet and return (in this case) the number of them that are Red? Thanks!
-
Help With Dates If Certain Criteria are met
Hi I am trying to work out how to Auto work out overdue date See attached i would like to get my Site Audit Complete column when marked "yes" to calculate the "Site Audit HN Dead Line" column's date continually move my overdue date to the current date each day until column marked Site "Audit approved" is marked Yes Is…
-
INDEX-MATCH Showing Wrong Information
I am using the following to pull a course title from another sheet: =IFERROR(INDEX({SubjectCourses-Titles-Credit}, MATCH([Subject + Course]31, {Subject+Course}), 3), "") It has worked fine with several course codes (Subject + Course), but when I enter an incorrect course code (i.e., it doesn't exist, such as HOS 419), it…
-
Referencing Data across Many, Many Sheets
What is the best way to do a SUMIF for data that's spread across ~50 sheets? This cannot be done with reports. My data involves how many hours our clients work in each state. There is overlap because a client may work in more than one state. Each of our 50 state sheets shows which clients work there and how many hours they…
