-
Formula to tell me how many times a word shows up, but only for a specific Review Board
Here is what I need: Count how many times Strongly Agree shows up, but only when the Review Board is General Medicine TAG. I have this to give me the # of times Strongly Agree shows, how do I ensure I only get this for "General Medicine TAG": =COUNTIF({Survey Intake - TAG Post Survey Range 2}, HAS(@cell, "Strongly Agree"))
-
IFERROR Function
Hi Community, I'm having an issue incorporating an IFERROR function into my existing function which identifies the average of averages greater than 0. However, the formula runs into the divide by zero error which I hope to default to 0% in event of the error. Please see formula below where I need to incorporate the IFERROR…
-
Smartsheet assistance.
@Genevieve P. I hope you are well? I haven't message in the forum for a while as my Smartsheet has expired and it has taken me a while to get a license. I was wondering if you can assist with a issue I am having with a project I am working on. I am creating a timesheet form and I require some sort of automation or…
-
Smartsheet assistance.
I was wondering if you can assist with a issue I am having with a project I am working on. I am creating a timesheet form and I require some sort of automation or something similar. In my sheet I require if one cell is change it populate another cell with something that is already logged elsewhere. for example in my sheet…
-
Formulas with Drop-down Multi-Select Column
Hi there! I have been using the new functionality of the "Drop-down Multi-select" column and I am trying to capture all of the different combinations that can be selected within the column. The column is supposed to capture the root cause of an issue and the person working on the issue is able to select multiple root…
-
Report with the last entry to each person's forms
Hi! I need to know how I can make a report with last entry to each "assigned to" with the row that generated into the Form. Anybody know how do it?
-
Looking for a way to auto fill the Label and Description on a form
Is there a way to quickly customize label and descriptions on forms? Like for example reference the field that contains the label and description information so it populates based on the primary value. Example I'm using the form as a voting ballot for prioritizing issues. The primary key is the Issue number then there is a…
-
Incorrect results extracting date from system Created (Date) column
I have a system column of Created (Date). This is [Snapshot Date/Time] in the screenshot below. I need another column that should reflect the DATE part of the system column. I am getting unexpected results in the date-only column. In the attached screenshot - you can see for both 4/21 and 4/22, the formula returns 4/22.…
-
Trying to identify cells in ALL CAPS vs Title Caps
I have a sheet where I've pulled a list of titles that exist on a series of URLs in either all caps or title case. I need to be able to identify or sort by the lines that are in all caps so that they can be corrected - is this possible?
-
COUNTIFS with 3 criterias
Hello all, I'm in need of writing a formula that takes into consideration 3 rows but one of them has values for which I do not care for. So I have Status (Complete, In Progress, Cancelled, Deferred), I have my second criteria which is a Yes/No column and I have my third criteria of values such as Blue, Red, Yellow. My…