-
Cross-Referencing Another Sheet for Matching and Looking Up Values
Hi! In my first sheet, I have a column "Date Submitted to Courseware". Then, someone selects an "Analysis Priority". First sheet The Analysis Priority should look up the References sheet to the columns for AnalysisPriorityTypeDropDown, match that, and figure in the AnalysisPriorityTypeValue number of days, and figure in…
-
Contact Sheet Help
Hi Community, I have created a "phone book" of names and email addresses for contractors in my organization. Each of the individuals has a row ID that is auto-number generated by smartsheet. Each of these individuals will be assigned to (usually) several projects during each year. I was thinking of assigning each project a…
-
Create a sheet summary, which counts RAID items and their statuses from another sheet
Hi there, I have a RAID log called "Work Allocation RAID Log" and I would like to create a Summary Sheet so I can see all the types and counts based on status - please see below Type (primary): Action Decision Dependency Issue Risk - with their statuses (columns): Not started In progress On hold Completed Cancelled This is…
-
A cross reference formula that was working before suddenly stopped working
I maintain a weekly project tracking system across two sheets: Sheet 1 (Project Status): Contains detailed project status updates Adds 20 new rows each week (one per project) Includes a 'Snapshot Date' column to identify the week Sheet 2 (Status Summary): Tracks project status counts (on-track/off-track) by week Previously…
-
Creating a metrics report - Sheet reference not working/displaying criterion
I have a metrics report I am building out for a dashboard, and have a column with a few drop-down options. I am trying to count how many of each category, and it decided it doesn't want to work. I am using the following, and this worked for the status column IE: Showing Started, Not Started, Resolved. But this column with…
-
Reference Another Sheet
Hi all, I am very sorry that I have to call for your assistance but finding the answer is not really straightforward. I have a formula that works, yahoo! but it works if I keep it on the same sheet. Now I want to use this formula that use all the data form another Reference Another Sheet (RAS). Do I have to add the RAS for…
-
Cross sheet functioning column formulas working perfectly...except for two rows?
Problem Summary: I have a series of formulas and cross sheet references which grab display data that meet certain conditions. They are working consistently across usage…except for two rows? For data sensitivity, I'll only be including the date fields out of the display data, but the same error applies to all final display…
-
Merged: Idea: Allow column resizing in "Sheet Reference Manager" so we can see full refer…
This discussion has been merged.