-
countif
Hi, I would like to count the number of ">3 hours saved" using the countif function. However, it is not working. I am writing the formula as follows: =countif(range, ">3 hours saved") the same issue with "<1 hour saved". Apparently adding the < or > signs is affecting the formula. Any suggestions please? I should mention I…
-
IF statement help
Hello, I'm trying to write an IF statement that checks three cells to determine if the values are equal and excluded blank cells. Below are the scenarios: cell 1, cell 2, and cell 3 all have the same value (not blank) = Yes cell 1 and cell 2 have the same value (not blank) = Yes I thought I could use: =IF(OR([cell 1]@row =…
-
Issue with Embedded IF Statement
I am working on a training tracker and am struggling with a formula that, while long, seems fairly straightforward. The column is a checkbox. And should be marked off with a check if the row is deemed a "required training". I am having an issue with the first part of the formula (The bolded portion below). Basically, the…
-
Formulas are working in the grid but not on the cross reference
Has anyone had this issue before? I'm using a formula to extract the created time from the system generated crated time stamp using the formula below. =RIGHT(Created@row, FIND(" ", Created@row, 1) - 1) The time stamp is working well in the sheet but is adding a comma to the output when I try to cross reference it in…
-
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?