-
Disable Dependencies - Use weighed Formula on % Complete
Good Evening I am wondering if something could possibly tell me what is wrong with the following. I need to disable dependencies on my Network Project Plan. I met with the pro desk, and we test using the following formula and helper column. It appeared to be working but I think we might have tested it with dependencies…
-
Ability to sort outside of heirarchy and then return to heirarchy
I have just built a Smartsheet with parent, children heirarchy. I would really like to be able to sort the data based on a column within the rows. The resulting sort of a (any) column wants to ignore the heirarchy, however, I do need to be able to return to the heirarchy. For example; First screenshot is data entry. Second…
-
Form not populating to sheet - please help!
Hi all, I built a sheet and form for an internship application I am coordinating. I have tested it several times, i.e. completing the form with test data and have not encountered any issues. I received a notification from Smartsheet this morning noting that I had a new submission - however, when I logged into the sheet,…
-
Help with Countifs formula with mutilple criteria on another sheet
Hello all, I am trying to get the count for the number of times "04A" appears in a list that only applys to certain people in a certain area. I am pulling the infromation from a existing smartheet The formula used is: =COUNTIFS({04A}, Title@row, {Bucke & Shroud Repair Range 2}, "GP GSC-GTVS-Greenville CRCOE TPs & Liners…
-
Count Formula Help
I'm new to formulas and referencing other sheets in SmartSheet and need help with the following scenario: We are wanting to reference another sheet to sum the number of days a team member is absent in a period of time. The referencing sheet has the columns of [Date Absent] and [Team Member]. The sheet where the formulas…
-
Absolute Reference Changing
Hi Guys, I'm having an issue with an absolute reference changing, I submitted a support ticket, but I wanted to ask here as well So I have a sheet that is submitted to via form adding rows to the top. The operator puts values in the form, and formulas return RGB if the values are good. I want to pull all the "Red" values…
-
When status changes in one sheet, how to get it to cross reference into another sheet?
Hello, I am trying to create a workflow when the parts status changes to "ready to schedule" in the Parts Log sheet gets copied into the sheet Project Management. I was able to create this workflow. The problem I am facing is that every time the status changes it gets duplicated into the Project Management sheet. How do I…
-
Moving selective data when original sheet is populated
Hi I have a form that populates a master sheet. How can I create a workflow that fills in a subset of columns in a second sheet after filling out a form? Smartsheet's workflow that moves a row to another sheet, unfortunately, moves a row and all of its columns. The issue is that I cannot use INDEX COLLECT or INDEX MATCH…
-
Formula in Help Section Not Working
Hello, I copied the formula that's given in the help section for the Year Function for selecting rows with the current year in a SUMIF formula and changed it to use my data, and I'm getting the INVALID DATA TYPE error. My date column is set as a date, and my column to sum is a number. What am I missing? Here's the formula:…
-
Finding Distinct Values from two different Sheets
Hello, I have a scenario where I'd been successful in summarizing the distinct users names who'd created entries in my sheet and done some calculations from that. Below is my formula: =IFERROR(INDEX(DISTINCT({NCP Originator}), Index@row), "") Now, my records have gotten to a point where I needed to archive older records,…
