-
A cell in a Source Sheet and link to Mutiple cells in a Destination Sheet
In my destination sheet, I want to link the values of a specific range of cells to A CELL in the source sheet. Is there quicker way to do the linkage? I tried to copy paste the format but the link does not apply to the rest of the cells.
-
Return the row number(s) that a CountIf, SumIf returns as TRUE.
Hi team! I have a relatively complex countifs(yadda yadda yadda) formula telling me if something is wrong with any of the hundreds of rows in a sheet. Now, I need a cell to identify the SmartSheet row numbers where the countifs() is true so the sheet admin can navigate right to the rows that have problems and correct it. I…
-
Checkbox is checked, dropdown menu changes as well as symbol changes
I have 3 columns: Checkbox Dropdown Symbol I want it so that the user can either click the checkbox or select an option on the drop down menu to change the symbol. This is done and working great for the symbol column! Now, I want it so that if the checkbox is TRUE and the symbol changes to GREEN, the drop down menu changes…
-
Hours by timezone
Hi there, I have two things I need help on: 1: Getting duration to show "3 hours" or "60 minutes": Start time (ex. 9:00 AM) End time (ex. 12:00 PM) Duration (ex. 3 hours) I used this formula to get a numeric number, but would love it to be "3 hours" or "60 minutes", etc. =(IF(FIND(":", [End Time]@row) = 2, VALUE(LEFT([End…
-
Creating a category column based off sub-categories from a dropdown column
Hi, I'm looking to make a column which returns the corresponding category for sub categories in another dropdown column For example, I have column 1: The text/number column for writing a formula to return the category and column 2: the dropdown for which I have subcategories. In column 1, I have categories X,Y and Z. in…
-
IF formula for between dates
I have dates in one column of a SmartSheet. I need a formula that tells me if the date is less than today and less than 10/25/22, return "Yes", if not than "No" Essentially I need the formula to return yes or no if the date is in the past and if the data is coming up within the next two weeks. Can someone please help with…
-
Index / Match with multi select criteria
I use a price calculating sheet for various criteria f.e. client or not, booking on short or long term and so on. A possible client uses a form to answer the questions and the price will be shown in another sheet "lead management" and the price will be offered to the interested people by an automation process. Is it…
-
Weekend recap?
Hi, I work in operations and it is 24/7. We have report out metrics that we use a smartsheet form to capture twice a day everyday. I need a report structure/sheet/cell formula to display metrics from only the weekend days in a year to administration folk that only work M-F. I have tried a workaround with…
-
Vlookup with multiple column input
Hi, I have a database that is updated everyday and i am looking for an entry(employee name) with multiple input criteria. i have tried this formula in excel but not working in smart sheet. =VLOOKUP(([PII ID]@row)&([Run]@row)&([Tech]@row), {BKR 28 feb Range 4}, 14, false). Can anyone help me to solve this problem. Thank you
-
Need Help with NOT CONTAINS
Hello, I need help with a formula using NOT CONTAINS This is my current formula, which is giving me an incorrect count. =COUNTIFS({Another Sheet Column 1}, CONTAINS("X", @cell), {Another Sheet Column 2}, "1", {Another Sheet Column 1}, NOT(CONTAINS("B", @cell)), {Another Sheet Column1} NOT(CONTAINS("C", @cell))) Values of…
