-
Using the Index(Collect) function to produce multiple results
Hi everyone, I'm looking for guidance on an index(collect) formula. I maintain a master list of independent contractors within Smartsheet. I have a secondary list documenting all independent contractors hired in the current year, which is broken down by project. In my master list, I want to add a column listing all the…
-
Summary Count w/ Multiple Criteria
Help please! I am trying to use the sheet summary to count with two criteria - Test Status and Region. I want to see the number of test scenarios that are in the US and Not Started, as well as Europe/Not Started, India/Not Started, etc. I have tried several variations of what I thought would work and I'm still getting…
-
How do I extract first and last name from an email address in proper form?
Hi, I am trying to extract the first and last name from an email address with the names in proper form (first letter capitalized). Is there a formula to do that? Here is an example of what I'm trying to do.
-
DataMesh Error
Hello Everyone, I have noticed that all 155 of my DataMeshes are currently experiencing errors and are not running. The error message displayed is "1: unknown error with source sheet." I wanted to check if others in the community are experiencing similar issues. If so, is the Smartsheet team aware and working on a fix?…
-
Sum of a column based on multiple factors
I want to take the Sum of Column A from another sheet if column B shows "Loan Declined" and Column C shows either "Underserved" or "Low-Income". I tried the following formula to achieve this but none of them are reporting the needed information: =SUMIFS({Column A}, {Column C}, "Underserved", {Column C}, "Low-Income",…
-
How can I automatically remove data with a value of zero from a Dashboard
I am looking for a formula to remove any line of data that has a value of zero in the Report, from the Dashboard. So, when the line of data is zero in the Report, it should eliminate that row from the Dashboard.
-
Return all unique values by Location
I am hoping that this is possible: I would like to look at Sheet "BIA All Data" and return all "Process Names" that match the "Site Name". For Test Site, there are Process 1 & Process 2 in the BIA Process Name field. =INDEX(COLLECT({BIA Process Name}, {BIA Site Name}, [Site Name]@row), 1) I would prefer that I could insert…
-
Formula issue
Hi Can I ….. So in my Traceker Sheet- I want to return a co- ordinators email when the relevanant team is selected - when "White Collar is select in the Tracker sheet, return the correct Email from the data sheet
-
IF Formula Help
=IF([% Complete]@row < 0.1, "Not Started", IF([% Complete]@row > 0.1, AND ([% Complete]@row < 0.99, "In Progress", IF([% Complete]@row = 1, "Complete")))) I need help with this formula. I need the row to say Not Started if % Complete is 0%, Complete if 100%, and In Progress otherwise. Help Please!
-
Sharing data among multiple sheets
I've created a sheet for the company to manage all Contacts. In a new sheet to capture more data about orders for a company, we would like to be able to pull over name and email address of a Contact when the Organization name matches in both sheets. I need this information to always be accurate in linked sheets when…