-
#ERROR
Does anyone know how to resolve the #ERROR? I saw previous posts saying its a problem with VLOOKUP or cross sheet formulas, but mine is on a simple formula on other columns of that same page. It was working fine all day, then suddenly updated to #ERROR. Will that go away on its own? I've tried refreshing the sheet, closing…
-
Index Join formula issue
Ok, I've been sitting on this for a couple hours and I just can't figure out what I'm missing. I have a column formula that is selectively working on certain rows, but there is no obvious difference between those rows. The formula is: =INDEX(COLLECT({APStepCode}, {SubcategoryID}, [SAP Subcategory ID]@row, {VBC ID List},…
-
Row Copying Issue
Hi I have a sheet, and in it there's a VLOOKUP to another sheet. I set a Copy Row Automation so that when the vlookup cell is filled, it should Copy the Row. I setup the Wrokflow like this: Trigger: When a Row is Changed When: <Field> Changes to Any Value Run Workflow When Triggered So, everything pulled into the sheet…
-
Check Box function not working
For some reason today I am unable to get a check box to work in a new sheet or even add one to an existing sheet.If I create a column and select "Check box" in the column properties, the empty check box doesn't appear. If I add a "1" to the cell then the "checked" check box appears.Any sheets I have with existing check…
-
Formula Issue with Symbols
Hi I used to be able to create a formula for a column that had a symbol that would automatically populate for example if Level="Milestone", "Yes","No" and this would automatically put a Star in the place where the task was shown as a milestone. This now only shows the word yes. I have deleted the formula and then converted…
-
How do I return Last Match with VLOOKUP
Hello, My VLOOKUP function is always returning the first match other than the last match. The lookup table is updated chronologically, and I need to return the most recent data which will always be the last match. I'm open to other solutions that use other functions. Thanks.
-
Multi Page Formula dragging:
I am working with multiple data sheets where my formula draws information from the same cell in 4 sheets, i.e. =SUM({pg1 cell1}, {pg2 cell1}). The formula works correctly, but when I try to tag and drag or C/P the formula into the rest of the cells in the column, it simple duplicates the same original cells, rather than…
-
COUNTIF Date is the same in 2 different columns
Hi, I would like to COUNTIF the date in "Start date" and "End date" columns, on the same sheet, are the same. It was quite simple to do it in an extra column per row: =COUNTIF([End date]1, [Start date]1) But would need to expand every time a row is added. Unfortunately, even after looking on the forum I didn't succeed to…
-
RAG Formula Used with Duration (Project Settings)
Smartsheet Community: I have a Formula (Below) that I am using for RAG but the Results come back Blank. Does anyone know if it is because the Duration is part of the Project Setting that is Hard Coded in Smartsheet? Formula:=IF(Duration@row = [Total Capacity (Hours)]@row, "Yellow") and Screen Shots
-
Is there a way to write a formula that will raise a flag to if row data for household size AND ...
I am trying to write a formula that will raise a flag if the row data fits specific criteria for determining income eligibility for a project. Basically it would be if the data on that row in the household size equals a number and if the annual gross income is less than or equal to a dollar amount, we need it to raise the…