-
How to create a formula to count # of values in a multi-value cell + other criteria using COUNTIFS?
Hello, I'm trying to count a value from a multi-value cell considering more than one criteria located in other columns. I'm trying using this formula: =COUNTIFS([LSP Name]:[LSP Name], CONTAINS("CNWQ", @cell), Active:Active, CONTAINS("Active", @cell), Function:Function, CONTAINS("MULTIPLE", @cell)) but is not working. Is…
-
combine multiple columns but retain data in separate cells
Hello, we're collecting RSVPs for a large event and one invited guest can bring up to 4 other adults and 3 kids (this varies from one invited person to another). I was asked to provide a list of all attendees A-Z in a single column as well as their meal choices. How can i combine all the names and meals into just two…
-
Sum based on multiple conditions
i am trying to sum a column based on multiple criteria. Example If "Capital Proposal C&D Cost" column is blank, I want to set "Total Project Cost" Column = "Final Roadmap Value" column + "Estimated C&D Cost" column Else, I want to set "Total Project Cost" Column = "Final Roadmap Value" column + "Capital Proposal C&D Cost"…
-
Matching multiple criterias
Hello everyone, I have a question on how I can use a vlookup to look up to parameters that bouth need to match to then give me a third parameter. I had to remove all specific company terms so this screenshots are now very generic. This is the formula I used: =IF({Sheet1} = "Country6"; [Assigned To]21; AND(VLOOKUP([Promo…
-
Formula to get best poll time
I have created a poll with dates as column headers and several times as multi-drop down options. It created a fantastic web-form I was able to share easily with collaborators both inside and outside my organization. My question is, is there a formula I could apply in the Sheet summary to count the best time for each date,…
-
Checking a contact field for a specific contact
We have a form that can be submitted by users for system change requests (CR's). When submitting the CR's the user can specify another user to be the primary contact. Due to a requirement to use Dynamic View were by default we want users to be able to see any CR's where they are outstanding and they are the primary…
-
If cell is blank copy value from other column in same row?
I have a form our Sales team uses for customer interactions. I'm trying to work around the inability of Smartsheet to copy only specific cells from one sheet to specific cells in another sheet. I thought if my workflow copies the columns from the source sheet with the form attached to it to the destination sheet and then…
-
if function with dates
Hello fellow people @Paul Newcome @Genevieve P. @'in you both as you always been helpful to me i have a list of dates in a date column as per screenshot below I need to know out of which of those are within the next 12 months i would really appreciate your input please
-
Formula for identifying duplicate data between cells in two columns and noticing blank cells
Hello! As the title suggests, I am trying to think of a Formula that will tell me if there is matching data in the two cells in question. I have a Helper Checkbox Column for this and this is generally the formula I'm concocting so far. =IF(ISBLANK(Office@row), 0, IF(COUNTIF(Office:Department, Office@row) > 1, 1)) This…
-
Search all of Column A, for the value listed in that Column C, Return Value in Column B
Hi All, I'm having a bit of an issue trying to figure out this formula in smartsheet. I have a sheet with the following columns: Facility Name (Column 1: This is a listing of all facilities we are contracted with) Client ID (Column 2: This is a unique identifying number for that facility) Facility Parent Name (Column 3: If…