-
INDEX MATCH Multiple criteria
Hello, I am trying to get the zip code based on city and state from a different sheet. The sheet that I want to return information from has 3 columns: City, State, Zip code. There are 20,000 rows in the sheet that I am trying to use as a reference with all the cities in the United States The sheet that I want to write the…
-
Child Cell Formatting
I would like for child cells to automatically appear for each new row, and then have an index/match formula be able to populate a column in the parent row from those child rows. For example: New air freight request- 5 child rows with default values of the 5 carriers pop up (can't do a dropdown, I need to track the 5…
-
Formatting A Sheet
Hi all! I am back again with another Smartsheet question! This time I'm not certain if what I'm asking for is even possible. I was wondering if it would be possible to format 3 columns to make them smaller and more digestible. At the moment, I have a sheet that displays dates tasks have been completed, the week of that…
-
Hierarchy and Child IDs
Good morning. I have to create 2 forms which will populate parent rows and child rows. I need the parent rows to have a unique quote ID (have this set up now), and child rows to either not have an ID, or have a specific ID that will tie back to the specific quote number. How do I do this?
-
Taking Average With Grouped Values
Hi all! I am very new to Smartsheet and am trying to come up with a solution regarding taking an average of matching column values. To explain in more detail, I have "Week Of" column and a "Days to Complete" column. I would like to take the average of the "Days to Complete", but only for corresponding weeks. Essentially,…
-
simple sumif formula not working
Hello, I am doing a cross sheet formula with a SUMIF. =SUMIF({CLONE BATCH ID}, [CLONE BATCH ID]@row, {CLONE CUT QTY}) I am repeating the formula I have used in other sheets. I re-watched the formulas video and am doing everything exactly a I should. Why am I still getting a zero for my answer. It is returning the number…
-
How to reverse the order in which a range is counted?
Hello, I have the following Smartsheet: In this Smartsheet, I'm building an asset booking system and, for the 'Asset Available During Your Booking Date Range?' column, it displays whether the particular asset is available for the date range inputted by the user. My formula is as follows: =IF(IF([Asset Booking Start…
-
SUMIFS within Date Range
Hi, I need help creating a formula to summarize an average using Sheet Summary Columns, I have the following sheet columns: Current Date, Average Rating, I have the following summary columns: From Date, To Date I have the following sheet summary column (locked) for our formula: Total Average Rating I'm trying that the From…
-
How to create pop up text in Smartsheet Dashboard
I am trying to creat an info icon so that when use scrolls over it, a pop up appears to explain the charts in the dashboard
-
When autofilling, prevent autonumbering
Hi, There are codes that I need to use that start with letters and have numbers after them. I want to be able to use the drag to autofill (in the lower right corner of the cell) the rows below it, with the same code. Every time I try, it autonumbers the rows below it which is very unhelpful. For example, my code is RP22…