-
Search, If & Input
I've been having some difficulty trying to solve this one: * I have a master sheet where forms are inputted * For each row there are two columns I need to set up in an IF for, and one where I need a value inputted from another sheet * I imagine it like this: IF column 1@row = {other sheet} …This reference should search an…
-
Apply non-working days of individuals to project plan
I'd like to allocate non-working days for individuals tasked with deliverables on my project plan. I have two Smartsheets: * Sheet 1 = A project plan - showing all allocated resources against multiple deliverables. * Sheet 2 = A Vacation Planner - showing all team members involved in the project and the days they are on…
-
IF AND OR
Hello all, I'm looking to use a Created By column to auto-fill my Primary column with a specific user's first and last name. I was planning on listing each user's email and full name with some variation of a IF/AND/OR or IFERROR statement, unless there's a more efficient alternative. Here is my current and one of many…
-
Checkbox if Date Past Due AND <100% Complete OR In Next 10 Days AND <100% Complete
Hello, I am trying to create a formula that will automatically check a box if a due date is past due AND % Cmplt is not 100% OR due date is in the next 10 days AND % Cmplt is not 100%. Basically, I will pull the checkboxes items into a report for a dashboard to provide visibility into past due items and upcoming items. Is…
-
Automatic data related to the check of another cell
Hello, I need that the data insert in a cell (column Data Open) will be automatically determined in relation to the data when the related cell of the row was ticked. Could you please help me? Thanks and regards.
-
Assistance with index formula
I'm in need of assistance on an Index formula. The situation is I have a master sheet with a unique number in the Primary Column. Another column has a flag. In my second sheet, I would like returned a list of the unique numbers from the master sheet where the flag=true. I have tried so many versions of this formula that I…
-
Calculating Values Per User Between Dates
Hi Guys, I'm probably missing something really simple but I'm struggling to get my formula to work. I have a metrics sheet that is using cross-sheet referencing to pull data from a separate sheet. Operators add values to the sheet and I've used the automated created date function to keep track of when the values were…
-
COUNTIFS Issue
We are using a sheet with count if formulas in order to graph progress on a dashboard. On the source sheets we have a dropdown menu with the following status options: * Prep * Working * Decision - RENEWING * Decision - MOVING * Housekeeping * CLOSED The COUNTIFS formula we are using works for all of the status options…
-
Pull in % Complete into a new sheet (pivot view)
Hi I am looking to create a ‘pivot’ view of my sheet that will show the 6 stage gates going across horizontally, so we can see going down the sheet how we are doing across all sites for system, users, WoW, etc. I have created a new sheet for this view and plan to reference in the 3 project sheets. It was recommended that I…
-
Vlookup #UNPARSEABLE Error linking to separate sheet
I get an #UNPARESABLE error message for a vlookup I am trying to create to a separate file in SmartSheet, I suspect there is a problem in the syntax. I've tried multiple tweaks to this formula with no success. As a check I exported the SmartSheet and the external file to Excel and had no problem successfully creating a…