-
Column Formula Question
Is it possible to convert a cell formula to a column formula if it references a different sheet? Here is the formula in question: =VLOOKUP([Project Name]@row, {AM Master Info List Range 2}, 5, false) Where [Project Name] is a column in the current sheet, and {AM Master Info List Range 2} is a range from a different sheet.…
-
Can I create a report/Sheet that would capture all conversations on multiple sheets in a workspace?
I have multiple sheets(Representing a job) in a workspace that have conversations. I am wanting to combine all of the conversations into one report or sheet to see all of them in one sheet. Can this be done?
-
Linking between different sheets.
Hi Everyone, I have a roll up sheet in which we have linked data from individual project sheets. Some data from project 1 will be row 1 in roll up sheet, project 2 will be row 2 and so on. One of my team members filtered the data in roll up sheet and when the filter was removed, all the data in roll up has disappeared (but…
-
How do I create a report that sums totals from my sheet?
Hi, I need to create a report that sums up the totals of each quarter on a report. How do I do this? I would normally use a pivot table in Excel for this, but I'm not sure how to recreate that same functionality in Smartsheet.
-
Ability for PM's to select which projects they want to receive a status update request e-mail
On an ad-hoc basis I need project managers to be able to select which project(s) they want to receive the status update request so they can update accordingly. Currently In my dashboard I give them access to a separate "project selection" sheet containing the project list (linked in from the master data sheet) and a…
-
Returning the most recent value that matches multiple criteria (cross-sheet lookup)
Hi All, I am trying to create a preventative maintenance schedule for our fleet vehicles and heavy equipment machines based on the vehicle/machine, the most recent odometer readings or machine hours, and the type of service needed (PM Service 2, PM Service 3, Oil Change, etc.). For my source sheet, I'm using a repair and…
-
INDEX COLLECT or VLOOKUP not working with numbers
I am in need of some help with trying to use either the INDEX/COLLECT or VLOOKUP functions. I have tried everything I can think of and nothing works. By employee number, I want to return their tenure. Both are contained in a reference sheet. Here is what I have tried. =IFERROR(INDEX(COLLECT({Tenure }, {Employee Number},…
-
Returning data from another sheet matching on two criteria
I am trying to create a report which brings back the actual performance for performance measures for the last month, 2 months ago and three months ago. But am stumped as to how i can do a lookup to the base data sheet using two criteria (MeasureID and where the date is last month etc.) The base data sheet has a row per…
-
Join collect with other sheet
I'm trying to use the best formula that will basically say.. If Distributor Name (sheet one) = Distributor Name (sheet 2), then input contacts (sheet 2) into contacts (sheet 1). There are multiple contacts on separate rows for each distributor on sheet 2 that I want to combine in a single cell for each distributor on…
-
Form Data
Hello totally new user to Smartsheet and need help on creating a form. I have looked at the posts but haven't found the answer, please help. 1) I need to create a form that will be filled by users to sign-up for different games. On the form my first drop down is Venue and that's the easy part, however when they select the…
