-
Nested IF with INDEX (MATCH)
Hi there! Hoping to get some help solving an index match issue I am working through. I want to use a formula that will pull a rental rate, from a rate card, based on the rental duration. There are 8 different rental rates possible for each item. Currently I am using, =IF([Rental duration cheat]@row = 1, INDEX({1 Week…
-
Populating fields across several docs using formulas - VLOOKUP, IF THEN, ???? Not sure
I have two worksheets that I am trying to populate a couple of fields. I have a dropdown/single select column in both worksheets that contain names. I am trying to populate the address, email, phone, etc from one doc to another. So If this name is the same from Column A in Sheet 1 and Column B in Sheet 2, I want to copy…
-
How to combine formulas
Hi, I'm a novice trying to make the following two formulas work together in the one cell in order to display as time format: =SUM([Project Hrs]1 * [Percentage Project Hrs]@row) And =INT([Project Hrs]@row) + ":" + ([Project Hrs]@row - INT([Project Hrs]@row)) * 60 Could someone help with correct formatting to combine the…
-
Syncing cells across sheets.
I have a process where I have multiple users entering data into their own individual sheets. I want copy from those multiple sheets into a single master sheet. I also want to update the master sheet cells any time a cell is updated from the individual sheets. I have been able to get this working, but the linking process is…
-
Calculate the Total Amount based on Currency Selected from Drop Down List
=IF([Currency]22 = "AED", [Amount]22, IF([Currency]23 = "USD", [Currency]23 * [Rate]23, [Amount]24 * [Rate]24))
-
Need a Clear Example of Using INDEX and MATCH in lieu of HLOOKUP
Hi. I've found plenty of examples of how to use INDEX and MATCH in place of VLOOKUP in SmartSheet, but no matter how many help topics and forum Q&As I've searched, I cannot find a clear example of how to set up INDEX and MATCH for an HLOOKUP equivalent in Smartsheet. Can someone please help?
-
Populating Entire Columns Referencing Another Sheet
Hi all! Over the last week or so I have been trying to build a report that shows average tasks completed over a given 12 week period. So far I have been successful in creating the formulas for these, which have been working on dummy data. Now I would like to process live data from another sheet. Well ideally I would…
-
Date Stamp Workflow Automation not working
I have a simple workflow automation that I created which is not working. It is a date stamp action to be recorded in a date-specific column, with the condition being a sum reached in a text/number column, and with the trigger being a row added or changed. My sum column (2022 - Total) works correctly, adding the sum of 8…
-
Average Percentage for Parent Rows
My current formula is calculating the average percentage of parent & children rows. How do I get it to look only at level 1 rows? Here is my current formula: =INDEX(COLLECT([% Complete]:[% Complete], Level:Level, 0, [% Complete]:[% Complete], <>0, [% Complete]:[% Complete], <1, [Current Phase?]:[Current Phase?], 1), 1)…
-
Formula to find the average word used in a column
Hi, Is there a formula I can use to find the average "word" used in a column? For example, I want to find the average of these words from the drop-down list: Cheers! Ann