-
Use of Averageif while filtering data in multiple columns
I am attempting to average %complete by team (Team#) where sessions are active (Sessions Scheduled). This requires two HAS(@Cell, Criteria) but I am getting an #UNPARSEABLE =AVERAGEIF([Team#]:[Team#], HAS(@cell, "1" AND [Session Scheduled]:[Session Scheduled], HAS(@cell,"1"), [% Story completed]:[% Story completed]) How…
-
IF/AND Formula with Dates
Hi all, I am trying to create a formula that will apply an X to a cell if the selected Date is between two other Dates (ie. Check In and Check Out dates). Currently I have a formula similar to what you would use in Excel: =IF(AND([TUESDAY 4/20]17 >= [CHECK-IN]@row, [TUESDAY 4/20]17 <= [CHECK-OUT]@row), "X") Check In and…
-
Is there a way to simplify this formula?
I have 3 columns with dropdowns of 'Complete' 'In progress' and 'Not Started'. In a fourth column (Percentage of Task Complete) I have a formula that assigns a value to each of those text items and then does an average and converts it to a percentage. Here is the formula: =(SUM(IF([Step 1]@row = "complete", 100, IF([Step…
-
Smartsheet Copy Rows Automation is Duplicating Data
Hi All, I have a Smartsheet set up which includes an automation to copy the rows to a second Smartsheet which works as a Pro Forma sheet for our Accounts Department. The idea is that we will input data into Cells as normal and then once our Client has approved the proposal, they will 'Approve' in Smartsheet via a dropdown.…
-
need to find values
here i have the data with few country names with status as pass , fail and on hold. attaching screenshots below. i need to figure out the values with the help of country names EX; AMERICAS = Pass (no of counts), Failed (no of counts) India = Pass (no of counts),Failed (no of counts) plz suggest me how to achieve this.
-
Per diem interest rounded to nearest cent doesn't translate to accumulated interest?
Happy Thursday!!! I've got a sheet that tracks loans to generate statements and payoffs. For the most part, it works GREAT. The "Holding Cost" (per diem) column is run by =[Loan amount]@row * interest rate / 365 Since the column is set for Text/Number & Currency, it automatically rounds to the nearest cent which is perfect…
-
Logic
Hi, I have created a form for leave request for my office. I would like to add a logic (or any other way) that "if the start date and end date are same" than a new field with the option to select a "full day leave or half day leave" appears. If suggest if its possible or any other alternative to do so. thanks in advance.
-
Auto filtering to another sheet
I have a grid sheet with a form for a training sign off(UTV). I'd like to take the date "Date" and name "Name" of the person who filled out the form and move/copy just these two columns to a new sheet. The new sheet has columns that are different than the previous sheet, in that the date I moved from the UTV sign off…
-
Minimizing Data in Email
Hello, I have created a leave request form for my organization. I have created a Automation in the leave request form. But when someone submit the form their respective supervisor and HR gets the notification with all the fields as per the main sheet. I would like to minimize it and only send the relevant data for the…
-
IfError with Index and Match
Hi all, I am trying to troubleshoot a formula that has worked for me in the past and wondering if anyone can look it over. Typically this formula is used for a travel grid that denotes when someone is Work/Travel Out (X/T) or just Travel Out (To). Happy to share the sheet itself as well to look at further.…