-
Count checked boxes in a column from another sheet
Hi All, I am working on a dashboard that displays various info and tasks in state of completion. I'm wanting to count how may checkboxes in a column to display a chart in my dashbord showing % complete. Based on other posts I felt it was a good idea to create a helper sheet that has the formulas and reference into the main…
-
Absolute Reference changes if cell is moved
Hi, Looking for help with Absolute references in cell formulas. I need the formula reference to remain the same even if the user moves or copies the cells to a different column. The scenario is Column8 has the formula =SUM([Column 6]@row, [Column 7]@row) If a user moves the Column6 cell to Column9 , the reference in the…
-
INDEX / MATCH and HAS / CONTAINS?
I'm determining how long a person has been parked based on the parking lot zone number and the amount of money paid. I have a separate reference sheet that lays out the zone numbers, location names, and all of the possible amounts someone could have paid in this lot - this is the sheet I'm trying to reference. When I…
-
Does anything in range A appear in column B?
I am trying to set up a formula that lets me know if any of the Project Tittles in one sheet appear in any comments on a separate sheet. When the function should return "True", I get "#invalid data type" =IF(CONTAINS({Project Tittle Range 1}, [Comments]:[Comments]), "True", "False")
-
Pivot Table Summaries Getting #REF Error?
I have a few pivot tables set to update weekly, and seem to be refreshing the actual numbers just fine. However, I have some summary functions set up that have totally stopped working, instead giving a #REF Error: I'm a little surprised, as it worked perfectly (with real cell references, not #REFs) when I originally set it…
-
IFERROR and MATCH Formula not pulling in formation - Prodactive S-Curve
hello, i came across a Video by Prodactive about S-Curves in smartsheet and so far everything has been working exactly as expected with one major exception; the "Actual" baseline. From the video and the downloaded examples, i used the exact same formula and referenced my sheet name versus what he had in his example. But…
-
Confused on Cross-sheet references
I have received the below message when attempting to create a Data Collection sheet: Unable to create cross-sheet reference, because this sheet already contains the maximum number of different cross-sheet references. I have read the many different cross-reference post but still find myself confused. Here is my situation.…
-
Too many Cell References Error
So i am making a sheet to keep track of different devices i mangage. While doing this i ended up with a lot of duplicate columns (Ex: Description column and another column named [DESCRIPTION] with the formula "=Description@row") Since getting the too many cell references error i deleted about half of the columns i had and…
-
How to show 5 different sets of checkboxes in same column?
Hi, I'm putting together a slightly complex master sheet for Dynamic View. It needs to show something like 5 different sets of checkboxes in the same column. I'm thinking I can achieve this either by creating 5 sheets, each showing the individual checkboxes OR a single sheet with the various sets of info in individual…
-
Looking for an option to Exclude rows from Dependencies/Predecessors
Currently, the only way to exclude a row from the Dependency/Predecessor function is to delete the row. This causes any Dependency/Predecessor reference to the row to change to #REF, which does not break the associated date row, but skips the #REF. Preferably, we would like to keep all rows, but have an option to exclude…