-
Help! This Vlookup is Driving Me Crazy.
Hi, I'm loosing mind with this vlookup and don't know if I should use an index/match. However, I have one sheet whereas I'm trying to prefill the 'Copy Ready' cells with yes or no based on if the value is found in another sheet and if in that same row where the value is found it's checked off as true under a column named…
-
Cross sheet reference strategy
Hi Folks, We have two sheets, which are used by two stakeholder groups. I've populated sheet B with some of the data from sheet A (the main sheet). To do this, there is a unique and corresponding ref on both sheets, and this has been used for a vlookup formula. We've now hit the max cross references and I've converted the…
-
Multiselect to single line item
Good Afternoon, I am looking to separate a client into their individual renewals from a master sheet that has the client renewal dates in a multi-select drop down: Live Clients List: Client Name Renewal Month Project Manager Client 1 January, July, August PM1 Client 2 February PM2 Client 3 March, September PM3 What I would…
-
Global Holiday settings
I am an Admin and set dates for holidays in the Admin Center, under Working Days & Resources - Working Days setting. How do I get these holiday dates to appear in each sheet When I go into an individual sheets created from templates, the holidays dates are not there. Is it because these sheets are created from templates…
-
Renaming Columns
I created a smartsheet using the Sales Pipeline template. I named the column, but now I need to rename it. I right-clicked on the column header, deleted the 4 words that I don't need (leaving the words that I do) and I get a message that says "Column Name is already in use in this sheet". The remaining words don't appear…
-
INDEX and MATCH help
Hello, I am building a dashboard to pull information off multiple sheets, and have created a separate "config" sheet to use formulas and organize the information to make widgets easier. I am looking to pull info from a date column in a project plan, based on a unique task name. I have a column in the config sheet that…
-
If Statements
Hello All, I am attempting to create an If statement that raises a flag if two rows have the same location and the same date. This submission sheet will be used when people visit a location and we do not want any double bookings. So I was planning on having a formula raise a flag and then have a report that looks for the…
-
How do I create a countifs formula if I have a column with multi drop down?
How do I create a countifs formula if I have a column with multi drop down and I need to specify which word to include for my count count? I would like to use the HAS function but it is not working as I am also referencing the data from another sheet so I can not use @cell with the HAS.
-
RYG health and status indicator roll-up
I currently have something similar like this setup for a number of projects, for each of the deliverables, I use the following formula: =IF(Status4 = "Complete", "Blue", IF(Status4 = "At Risk", "Yellow", IF(Status4 = "On Hold", "Yellow", IF(ISBLANK(Finish4), "", IF(Finish4 - TODAY() < 0, "Red", IF(Finish4 - TODAY() < 3,…
-
JOIN Function
I have followed all the instructions but really struggling with this. I am trying to show items from several columns in Calendar View. I read this can be done using Join Function for the primary column. I used the same formula and was able to get it to work for two columns but when I attempted to add more I get an error.…