-
Formula to check the cell for 4-5 text strings
I have a condition where in the formula should check the text in CELL A and return value based on the assigned values and should leave the formula cell BLANK if none of the condition is satisfied. I tried it through spreadsheet and the formula is: IF(OR(A1= "Name A", A1="Name B",A1="Name C",A1="Name D",A1="Name E",A1="Name…
-
COUNTIF using multiple criteria
I am trying (what I thought was a simple formula) to countif using multiple criteria. I have a drop-down column. I want to calculate the number of "yes" and number of "Maybe - Depending on caseload" for the CHILDREN. I am using: =COUNTIF(CHILDREN(), "Yes", [CHILDREN(), "Maybe - Depending on my caseload"]) but it doesn't…
-
Automatically adding a new row when a new phrase/word is added to a colomn
I don't know if this is possible at all. So I have a column and it's the importance of the tasks in the sheet. I have another sheet that has a summary and tally up how many tasks are there for each severity level. Someone did this manually. First, I want to ask if there is a way to produce a column of the severity column…
-
Bulk adding users to group
Hi, I am trying to add a bulk of emails into a smartsheet group. It is suggested that you can do this by pasting email multiple email addresses into the " add members" fiels; however it just returns " please enter a valid email" I have tried all formats of entering. Please advise as I have many contacts to add!
-
Add a specific condition to an existing formula
Hi, I am trying to ad a specific condition IF(TD<[@[DUE DATE]]+7,"PIPELINE" to an existing formula. However, the existing condition IF(TD<[@[DUE DATE]],"CURRENT" is interfering with the addition, and I cannot figure out where I am going wrong. I tried all sort of combinations. The complete formula is:…
-
Use Zapier to populate a column based on the date a comment was added
Hi everyone, I am trying to use Zapier to add the date to a row that reflects when a comment was last added in that row. I thought I got it up and working, but ran into an error when I moved from testing to implementation. I used the "New Comment in Smartsheet" trigger and returned the Results Modified at by referencing…
-
Formula for counting values from single-select drop down on a form
Hello, I'm trying to figure out how i can count or which formula i can use to count how many people selected their desired choices from three different categories (single-select dropdown) that falls under 3 different groups. I created a form out of a sheet and my question is when people are going to pick their top 3…
-
Countif coming over as percentage
Hello, for some reason I have one formula using a cross sheet reference that comes over as a percentage when the rest come over as values which is what I want. I really don't understand why the "complete" formula is coming over as a percentage and not an exact value. Thank you in advance for the help
-
How would I return a specific status based on differences in multiple other cell columns?
I am attempting to create an automatic status update that is driven by different options selected in multiple other cell columns. For example: I want my Status column to indicate "Assessment" if another column regarding the assessment is marked as "Yes". However, if another column regarding a meeting is marked as "Yes," I…
-
referencing using @row
I've tried multiple searches and haven't found the right keyword/tricky phrase to answer my question. I am using a form for submissions and trying to calculate how long a trend has been occurring. Right now my working formula is this: =IF(DidIncidentOccur@row = "Yes", 0, IF(YEARDAY(Date1) > YEARDAY(Date2), DaysSince2 +…