-
Converting text to number
I have a dropdown column with categories that I want to convert to numbers in another column. For example, if the value in the dropdown column is "REPORT", then I want the other column to be the number "12". If the value in the dropdown column is "GO BACK", then I want the other column to be the number "5", etc. I have…
-
JOIN DISTINCT CHAR(10) List on Sperate Rows
Hi, I have the following formula which collects a list of a dropdown column, and removes duplicate values, is there any way that the returned list of values should be on separate rows of this column formula? =JOIN(DISTINCT(Dropdwn:Dropdown), CHAR(10)) Thank you,
-
What formulas should I use to count two criteria (including from a multiple dropdown option)?
I want to count "Enrolled" from "Case Status" AND "Medicaid" from "Insurance Type." I used the COUNTIF formula, but it seems like Smartsheet isn't counting the Medicaid cell if it's within a cell with multiple criterias selected. Screenshots below: You can see that even though 2 fit the criteria, the sheet summary only…
-
Help with cross-sheet sumifs
Hi All, I'm getting an #Unparseable error, and I'm too tired to see why. Any help would be greatly appreciated! In the source sheet, I've got invoice data. In the destination sheet, I want to be able to sum all the invoices for certain Project Codes. Here's what the source sheet data looks like: And here's what I've got…
-
Reports Using Grouping Not Showing Dropdown List
Hi There, I have a set of reports I use to summarize a large set of sheets that are used to track different workgroup meetings, the attendees, the attendees companies, and a category we've set the type of company. I use the summary reports to reconcile, for example, Jane Doe is listed under ABC Company in all instances.…
-
Formula For conditions
I have a column in a sheet called Notes, in which people enter how many notes they have done for the week. I need to assign points for what they did, and here are the details: 1 point for every note, regardless of how many. In addition to that, the following: If notes are less than 9 it should be -1 point or If notes are…
-
Returning Matching String Values Once
I have a {Client} row in an external sheet. Certain client name can appear multiple times. I am trying to have it listed once . I tried DISTINC, MATCH and no luck. =DISTINC({Client})
-
Workflows - Weekends
Good morning, Hoping someone can help here. Is there a way to stop automations/update requests from running on Saturday and Sunday? Automated emails/update requests are being missed by staff since they are sent on non-working days. Does anyone have a solution for this? Thanks!
-
How do I count one column dependent upon if another column meets a certain criterion?
Apologies, I am having trouble finding the correct syntax for a COUNTIF formula that counts one column only if the other column fulfills the criterion. The criterion is to match a single dropdown selection on one sheet to a given cell in a separate sheet. For example, in the screenshot below of my metrics sheet, I would…
-
Asset Availability Formula
I am trying to create a formula which allows me to input 2 sets of dates (a check-out date and a due date) which will then present me with the availability of the total assets between those dates. Does anyone have a formula that calculates availability based of existing availability/unavailability? I hope this makes sense.…
