-
First & Last mentioned date in the column related to a matching cell in a row containing value
Hi, I have a value in cell [Crew*]4 - "Max Test" In cell [Start Date]4 I want to have a date from column Start40:Start50 related where "Max Test" was mentioned the first time in column [Crew*]40:[Crew*]50. Similar in [Forecast Finish/ Completed*]4 I want to see the date from column [Forecast Finish/ Completed]40:[Forecast…
-
How to Remove Apostrophes in Front of Numbers?
Hi all, My problem is SS has put in apostrophes in front of numbers after importing from excel. I have a column that is comprised of both text and numerical values. I've tried using a value function to remove the apostrophes. This works for the numerical values but shows errors on any cell containing text. Does anyone have…
-
Index/Match from multiple selction drop down, bring in selections to other sheet
Hello, this has been asked a lot but I can't find a similar scenario. I have a database with SKU, in the approvals column of the row each SKU has multiple approvals listed based on drop-down selections. I have a change request sheet where changes against the SKU are requested. I need the change request sheet to index the…
-
Help with contains function.
We have multiple end users of our product I would like to count how many go to these end users and satisfy a list of other criteria. I would like to wrap the contains formula within count if formula. My "handed over to" can be x, y, z, or any combination thereof I would like to count how many entries have been handed over…
-
SUMIFS Question for adding a criteria for a column sum function
Hello! I am working on creating a travel budget dashboard for my team. I threw in some random numbers but essentially I am creating this data sheet to reference my main sheet where I house all travel budget requests. In my other sheet I treat as a data repository of all requests I receive. The above {cost} and {Dom or Int}…
-
Health Status/Rating calculated by Removing Specific Task names
Hello Smartsheet Community, My team and I are looking to improve a formula that helps to roll-up a score/health status of all of items within an activity plan, which is our RAID Log (Risk, Action, Issue, and Decision). We have a formula that calculates an aggregation/overall rating of all of the risks we have identified,…
-
Need help showing child row statuses in parent row status
Hi! I need help creating a formula that shows the child row statuses in the parent row. Is the below possible to build into a formula that I can pop into the parent row? Show “Not Started” if all child rows say “Not Started” Show “On Track” if any of the child rows say “On Track” Show “With Client” if any of the child rows…
-
IF CONTAINS INDEX MATCH Formula
I would like to be able to create a report where I can see Activity A, Finish (of activity A), Report A, and Finish (of Report A) in separate columns. I don't want to use group functionality in Row Report as it becomes messy when pulling it multiple activities from 50+ sheets. Hence, I would like to create two additional…
-
VLOOKUP #NOMATCH error linking to another Smartsheet
I get an #NOMATCH on what I believe should be a very simple lookup. I haven't found a previous discussion that solves my particular problem. My formula is: =VLOOKUP("Park", {Parks Master List Range 1}, 10, false). When I set the sheet reference to that range, I did so by simply selecting the columns in the reference sheet…
-
Possible to copy data to cell if only one of multiple columns contain information
Greetings, Is there a formula that can be used to copy the text from a range of columns only if there is information in that column? For example, I have Columns [Name A], [Name B], [Name C]. Only one of these columns will be filled at the any time. If one of those columns has information, copy that information into Column D
