-
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โฆ
-
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โฆ
-
Help on formula
Hi I am fairly new to Smartsheet (3 whole days) 2 questions. I have a dropdown box titled 'Finding Rating'ย with 3 values: Conformance, Minor Conformance and Major Conformance. 1.Needed a count of each type (so i can create a graphs, onย dashboard),ย I created another 3 columns titled Conformance, Minor Conformance and Majorโฆ
-
If, Then Formula
Hi everyone, I've searched through the community but couldn't find the right solution. I need to feed specific sales metrics into a dashboard but wantย it to update, accordingย to the Today column. I receive the previous months information on the 15th of each month, so the formula would need to cover a 45 day period. I addedโฆ
-
AUTOMATE RYGB
Hello All, I am trying to automate the blue ball based on complete and the red, yellow and green based on date. I have come up with the following formula but I am getting an UNPARSE any help would be great. =If(Status1 =Complete, "Blue", IF(OR(ISBLANK([End Date]1), [End Date]1 >= Today(-5)), "Red", IF([Endโฆ
-
Report Viewability
So I have created several Reports and have noticed that when you add them to a Dashboard, anyone with Dashboard Access can view them as a Widget; however, When made a viewer on the Report itself, all the people see is a blank page. Do the Viewers also need access to the sheet the report is pulled from? If so then reportsโฆ
-
RGY Status - Overall Roll up
Hello helpful Smartsheet-ers! I have several rows that are utilizing the RGY buttons for health. I am trying to roll these up to a general status based on the choices in the individual rows. Can anyone help with a single formula that would capture: Green if all elements (rows) are green Yellow if one or more elements areโฆ
-
Formula for common end date
I'm trying to figure out how to have several tasks point to a common end date. The tasks have various implementation dates but the "go live" time period ends at the same time (i.e., 2 tasks - one completes on 6/13 and the other completes on 7/1 but the project end date is 12/31 for both...so different durations and I don'tโฆ
-
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โฆ
-
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โฆ