-
Rounding Formula
Hi, I'd like to round the result of the division in this formula to the nearest whole number. =IF([Column1]@row = "Text1", [Column2]@row, IF([Column2]@row = "n/a", "n/a", [Column2]@row / 2)) I tried placing MROUNDright before the last section of the formula like this, but I got the error "INCORRECT" =IF([Column1]@row =…
-
Row # on Another Sheet
Hey! First thanks in advance for looking. Is it possible to get the row # on another sheet? I want to know the Row # for New: Release Update Sheet. New: Release Update Sheet Release (would require Is Parent to be checked) Row ID (Auto Number) Release List (This sheet is where the formula would go) Releases Auto (Auto…
-
Cost Calculation with Multi-Select Dropdowns
I have an intake sheet for samples received for testing in my lab. I originally set up a multi-select drop down column where all requested tests could be selected. Originally the sheet was set up to track studies submitted over time, but now management wants to incorporate cost into my dashboards. I'm trying to figure out…
-
Find FedEx Number with the Latest Date
I have duplicate DEVICE NAMEs with associated FedEx numbers and different RECEIVED DATEs in the target Sheet above. I have another sheet (my Source Sheet) that has a list of corresponding Device names that I need to match against the Device Name in the Target Sheet. If a match, find the latest RECEIVED DATE associated with…
-
I need help to sum all data by month & owner in one column for a pivot table for our dashboard.
This is our raw data sheet. For the pivot table chart I need to sum the location total for each owner. by month into one single column in my pivot table sheet. The pivot table sheet will then display on our dashboard. And the pivot table is not an option for us right this moment. Here is our pivot table chart so you have a…
-
Import a formula via workflow
I was playing around with the workflow and almost got a formula imported However after the formula got added it leaves a ' mark before the formula , that must be manually be removed for it to actually take effect Kind Regards Brandon Austin
-
Retrieving Ancestor (date) value from multi-level parent-child rows
Hi All, I used the following formula to retrieve ancestor (first parent) date value of the multi-level parent-child rows for each row. =LEFT(INDEX(JOIN(ANCESTORS(Date@row), ","), 1), 8) The issue that I'm facing is the return value being "TEXT" despite having "DATE" column type. Since I have to use this return value in…
-
Support - Formula that calculates difference between times in a quarterly increments
Hi Smartsheet Community, I'm attempting to figure out a simple formula that would calculate the difference between 0800 and 0830 in quarterly increments. At this current time i'm unable to figure out how to create a successful formula that would show the correct -0.50 for the following. Should 0825 and 0900 be entered, the…
-
Use IF THEN Formula
IDK what I'm doing wrong as it Allllmost works. Trying to create a formula to say, If you look at this overall score... if it's 0 - 54 = Tier 3 If it's 55 - 90 = Tier 2 If it's 91 and beyond = Tier 3 I'm using this formula... it works except it won't display tier 3... =IF(Answer21 < 55, "Tier 3", IF(Answer21 > 54, "Tier…
-
Index Match question
Hello, I have 2 sheets, 1 is a tracking sheet, the other is a reference sheet. I need to pull into the tracking sheet a dollar amount from the reference sheet. The dollar amount is based on the information pulled from 2 different columns - Job Title and # of hours. I tried to use a join function to simplify the index…
