-
auto populate data from one sheet to another
Hello everyone, I'm new to Smartsheet but do have a fairly robust knowledge of Excel. I've created a sheet with job codes, associated titles, and pay rates. A row has a venue name, a job title, a department, and a pay rate. I would like to create secondary sheets where if a job title/department/pay rate is added to the…
-
Pulling Data from Second Sheet
Two Sheets: I have one sheet labeled "Permits" and one sheets labeled "Project Tracker", Each sheet has a Column Labeled "Job #" and "Permit #". What I'm looking for is if Job # match on both Sheets in column, Permit number column on Permits sheet is copied to project tracker sheet column.
-
Wrong date format on hyperlinks
Hello all, I have searched this topic but can't find anything. I'm using UK date formats in my companies sheets and our account is set-up in UK format, however when I link a date from the source sheet into the new sheet the date is displayed in US date format. Is this a glitch or are we doing something wrong? Tom
-
Pull reference data from another sheet while filtering out based on a multi-select dropdown
Hello, I'm new to Smartsheet and I'm having a bit of trouble with referencing data from one sheet to another. I think this question has been asked multiple times, but I'm confused on the format of the formula's as this is a complex problem. I want to have a master 'Parts List' which is a complete list of parts with some…
-
Trying to Work with the VLOOKUP Function but hitting a wall
I'm attempting to access a separate sheet with some contact details for various clients. On my CLIENT SHEET I have 8 columns: Licensee, Billing Company, Contact, Contact Email, Street, City, State, Zip On my PROJECT SHEET I have various other project details, but one column is also named "licensee". In the Licensee column,…
-
Count how many jobs start in a month
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
Column Number Function
Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
-
Columns do not line up if hidden if referencing 'in' from another sheet
Hello! I am referencing a single row of pertinent information into "Sheet #A, Master" from multiple other sheets "Content Sheet #b"; "Content Sheet #c"; "Content Sheet #d"; and so on. That works, but when I first build the link ALL of the columns in "Sheet #A, Master" need to be unhidden first. This is definitely a rich…
-
Date use with COUNTIFS formula (Non-Specific Date)
I have set up a summary grid pulling information from another Support calls grid so I can keep track of logged calls completed by members of my team. I am currently using the formula below to pull that information for one of the team and it works fine. =COUNTIFS({Support calls Range 1}, "Complete", {Support calls Range 2},…
-
Formulas and Links to Other Sheets Disappeared
I have a large project sheet that contains (1) cross-sheet links and (2) formulas to calculate due dates based on other tasks. I needed to change the sheet to only populate weekdays (no weekends) so I turned on the dependencies and edited the workdays. Then I realized ALL of my cross-sheet links and formulas disappeared! I…
