-
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
-
Issues with Numbering Children (Child 1, Child 2, etc.)
Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following: Create an auxiliary column with a "1"…
-
Error In Filtering Parent Row Formula
In my metric sheet, I am receiving the #INCORRECT ARGUMENT SET error on code I made trying to only count the child rows in my reference sheet. =COUNTIFS({Is it implemented?}, 1, {evidence attached 1}, "Yes", {Parent?}) I wasnt sure what part of my reference sheet I was supposed to click on to add the "Parent?" part, so I…
-
Checkbox Formula Not Working in Metrics Sheet
I am trying to make a metrics sheet that shows how many checked boxes there are in my sheet. The tutorials I found said that "true" and "false" mean whether the box is checked or not. Why are my results showing as 0? I should have at least 20 as checked. I used the formula COUNTIF({checkbox 1}, [Column7]@row) This was…
-
INDEX/MATCH works in one sheet, same formula gives #INVALID OPERATION in another
Hi all I have a Project Info section of my schedule sheet that I pull into columns so that the info can be used in automated emails about tasks. The sheet that's giving me problems is a copy of another sheet, where the formula works. =INDEX([Task Description]:[Task Description], MATCH("Portfolio", Task:Task, 0)) It works…
-
Auto Populate Cell Reference by field names
This is going to be hard to explain, but I'm hoping I can do it. I have a sheet named "ProjectSheet". Under Task Column I have multiple "Applications". Under each Application is a Project Stage (Data Gathering, Build, Post Go Live). Under each Stage are two roles (IC, IE) (Top - image) I have a second "Team_Dates" sheet…
-
Dynamic Drop-Down
Does anyone know if the options in a drop-down can be linked to a table? I have a sheet that users can pick a "provider" from a drop down list. That provider is associated with a vlookup that helps to populate other columns in that sheet. However, the "provider" list is dynamic and changes when a new provider is added to…
-
Return latest value from another column's latest rows
Hello, I have a sheet in Excel I'd like to move to smartsheet to work with a client's team. The only problem I have is with the fields "Previous Cumulative Partner Discount" and "New Cumulative Partner Discount" as they have formulas that involve each other column in theirs and in Smartsheet it returns the circular…
-
Modify Baseline start and finish dates
The column isn't locked but I cannot modify those dates in the columns. Solution?
-
Masking certain columns to viewers
Hi all, We have a main spreadsheet where we keep all of our projects including the budget for those projects. I would love an option where I can either share that spreadsheet, but mask certain columns or duplicate that spreadsheet, but not fill in the budget columns and then share that spreadsheet. Is there any option like…
