-
Sharing lessons learned - hiding rows & columns - replicating formulas across sheets - disaster plan
Warning! Long-ish post coming your way with multiple topics I wanted to share. Throughout, if I’m missing a functionality whereby I’m needlessly fretting, please, please let me know. Intro Hiding rows and columns administratively across 20 unique Sheets Porting in and out of MS-Word for large find / replace formulaic needs…
-
Combine Contact Lists
Hello. I am trying to combine contact list A with the Created By column into one Contact Helper column to use in order to restrict the user view in Dynamic View. Here is my problem. Contact List A is filled in from a form submission. The user is supposed to enter or select their email address along with the emails of any…
-
Start Date Formulas not appearing in reports
Hi community - ran into an issue I've never experienced before. Across all my clients, we use formulas to project dates (we've used durations/predecessors in the past, but it's not our preferred method). If we look specifically at the "TEST - SD - Internal Scope Alignment Call" line, you can see the "Start Date" formula,…
-
Assistance needed with the following formula...
I'm trying to put the correct data (person) in the correct column for an Employee and their Management hierarchy, using the following formula: =IF(VLOOKUP(Worker@row, {Active Workers Report - Mgmt Lvl}, 5, false) = "Team Lead", {Manager}, "") Can someone help me correct the formula, so the Name of the Team…
-
Formula result is "N/A". Automation does not seem to evaluate it properly
Hi, I have a formula in column C such that: =IF(ISBLANK(column A), column B, column A) column B is also a formula, and the result is sometimes N/A. In the column B formula this result is written as "N/A", so it comes in as text with no leading or trailing spaces. Also, column A, B, and C are all multi-contact columns. When…
-
MAX Formula Cells Updating in Reports
We have two cells with 'planned start' and 'planned end' dates. We also have two cells for 'actual/revised start date' and 'actual/revised end date'. These are designed to allow managers to enter the estimated start/end date of a milestone, and the revised start and end date when things slip. The actual/revised end date…
-
COUNTIFS - count the number of dates that fall within one month
Hi Community! Hoping you can assist. Can you tell me what is wrong with this formula for counting how many publications that fall within one month? =COUNTIFS( [Publication Date]:[Publication Date], >=EOMONTH(TODAY(), -1) + 1, [Publication Date]:[Publication Date], <=EOMONTH(TODAY(), 0) ) The date in the Publication Date…
-
Cross-Sheet Formula Help
I have two sheets: the first sheet is called 'Source Sheet', and the second is called 'Helper Sheet'. I want to use the Helper Sheet to track survey responses that are fed into the Source Sheet. The formula should reference a column in the first sheet named 'Company Email'. If that column is not blank on the Source Sheet,…
-
Formula to pull multiple contacts cells into a single cell
Need a way to concatenate multiple contact list cells into one sell for automation
-
How to pull the title from a hierarchy at ancestor level 0
Hi All, I just want to pull the title 'BSR Tracker' in column 33 Please note there's another Blue bar in the same tracker i.e. two levels at ancestor = 0 so i just want to pull that title in. currently the formula im using but doesn't seem to be working is: =IF(COUNT(ANCESTORS([Site Name]@row)) = 0, "",…
-
Adding Months to the Same Column
I am trying to setup a sheet that can project dates decades into the future. I want a formula that can look the date in the row above, check to see if it's annual or quarterly, then add the appropriate number of months to each row. While testing the formulas, I keep getting stuck on how to add one year (12 months) to each…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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, <>"")