-
#INVALID DATA TYPE error with IF function
I have set up a separate column to convert my progress bar values to numbers to be used in downstream calculations. This formula works to convert "Empty" to 0, "Quarter" to 0.25, "Half" to 0.5, and "Three Quarter" to 0.75. However, if I change the progress bar to "Full", the error #INVALID DATA TYPE appears instead ofโฆ
-
Vlookup or match index?
Hi there, I'm wanting to know how to autopopulate the [Supplier Rep] column when a particular [Supplier Name] is chosen I already have a list in a different sheet to reference from as what would be the correct formula?
-
Excluding Blank Cells in Formula
I have a master row that I would like to track the year's progress. In my image, I would like the [Status] ball to stay Green if "YES" and if blank in [Count] cells January - December. Want it to turn Red, if there is aย "NO" in any [Count] cell. If all [Count] cells are blank January - December then "Blue" YES followed byโฆ
-
I have messed up one of my formulas and don't know how to fix it.
I have accidentally deleted one of my formulas and can't get it working again. Please help. I need to do a vlookup but I keep getting a no match error =VLOOKUP(Project1, {Project Ref Number}, 1, false) this is my formula, not sure what the problem is, unless there is something with the reference table. What I am doing isโฆ
-
#INCORRECT ARGUMENT
I am trying to create an IF-OR statement however I'm left with #INCORRECT ARGUMENT SET.ย This formula works on Excel however I have issues with smart sheets. =IF(OR([Mi-Tech Status]4856 = "Canceled", [Mi-Tech Status]4856 = "Transferred", [Mi-Tech Status]4856 = "Cancel", [Mi-Tech Status]4856, IF(ISNUMBER([Splice & Testโฆ
-
has anyone had issues with workflows becoming randomly invalid
Below is the automated response I have been getting on a couple of project that I manage. Any help or suggestions on how to correct would be greatly appreciated. Best, Anthony D'Ambrosio PMP-16-0244 POR-18-CH&HKR-AMZ Portfolio Workflow Delivery Alert The following people included in the Alert workflow for "PMP-16-0244โฆ
-
IF statement with multiple values changing symbols
I have a bunch of columns that have different check boxes to signify if certain paperwork is completed. I have figured out how to change values on the symbols by creating an extra switch column for the color dot symbols to appear, when one of the boxes are checked. My issue is, I need to have the colors change as valuesโฆ
-
Need help creating a formula
I do a project status report for my team. We currently have status options like: "Not Started" , "Active", "Active + Concerns" and "Complete. I recently made another status option: "Cancelled - Covid19". I make a dashboard for my supervisor that highlight the number of projects that aren't complete due in the next 7 days.โฆ
-
IF & AVG functions
I'm looking to create a report of averages and actuals to help predict spending. I'd like to create a function that does the following: Displays the average spend for YTD if today's date is less than the 1st of current month Displays the actual spend for the month if today's date is greater than the 1st I'm starting with,โฆ
-
Multiple Sheets for Average
I am trying to put together a master metric sheet. Within this sheet, I need to pull the averages from two separate sheets into one. We currently have a flow that when it is completed on one sheet, it will automatically populate to an "archive sheet". Both of these sheets need to be captured in the average calculation. Iโฆ