-
Help with Cross sheet Date Value not being treated as a Date
On my sheet, I have a Planned Migration Date column that has discrete date values for each row. I have another column called "Migration Week Monday" where it determines Monday's date for the associated Planned Migration Date. My formula works well on the sheet up until I use a cross sheet formula to pull in the date value,…
-
Index Match Returning No Match?
Hello all. I've searched for a solution but have not found one. I am using an index match formula to return an "employee name" based on a "project name" match. The formula returns no match…but there should be. Scenario: I have a sheet which lists projects including: project #, project name, super, etc. I used a formula on…
-
Additional Criteria changes result
Hi folks, I'm struggling with a formula that should be simple. When the formula is this, it works great for one of two Types. The second type pulls the wrong Billing Annual Fee. =IFERROR(INDEX(COLLECT({Billing Annual Fee}, {Segment}, Segment@row, {Billing Ownership}, [Billing Ownership]@row), 1), 0) When I modify the…
-
Hammock Task Creation
One of my clients uses Hammock Tasks to represent Project Management and Organizational Change Management in their projects. A Hammock Task is one whose Start and Finish dates are driven by different Milestones. The Start Date would be the date of one Milestone and the Finish Date would be the date of a subsequent…
-
Need help with a formula to determine if all responses have been received for each group in the Smartsheet
Hi! Thanks in advance for taking a look! I have a Smartsheet that has a line for each person being reviewed as well as their "client number". I created a helper row to let me know when each person has completed their actions, but I'm having a hard time finding a way to indicate when everyone for that client number has…
-
Why the dropdown menu is not searching for the first characther anymore?
Since a few days ago, the smartsheet started working differently. I used to write in a cell with dropdown menu the number "5" for example, and would show me the option "5 - built" straight away as first option. Now if I do the same, the first option that appears is "0.5 - waiting", this is really annoying because after…
-
Display Attachment Names in a Column
Hi everyone, Is there a way to display the attachment name(s) in a column?
-
Checkbox if a multi selection drop down is used
I am currently trying to check a box if there are multiple options selected from a drop-down menu. The goal is to check the box if it has more than one workstream selected from the drop-down menu. There are multiple options that can be selected which are listed below. Servicing Transformation Production Transformation…
-
Count days from Start Date enetered and stop count when Finish Date is entered
Good day, If someone could please assist. I'm looking for a formula that counts my "wayleave" days starting from since the "wayleaves have been submitted, and stops the count as soon as the Actual Finish date is entered for the "Wayleave". Ps. Should also be "NETWORKDAYS". Example Columns: Column "ROW 1 Actual Start": Date…
-
COUNTIF Cells within a range are NOT BLANK
Hello, need help with a formula - I need to count within a cell range how many are NOT BLANK, this is the formula I currently have that is not working - what needs to be changed? /COUNTIF(Charter@row:[Retrospective/Lessons Learned]@row, <>"")