-
sumifs pulling from separate page for last 45 days with additional criteria
I'm trying to pull a total quantity of bad parts that have been made in the last 45 days. I'm looking to break this down by specific part numbers. The formula that I'm currently using is : =SUMIFS({Machine Shop Scrap Data Range 1}, {Machine Shop Scrap Data Range 2}, AND(@cell >= TODAY(-45), @cell <= TODAY()), {Machine Shop…
-
No "reference another sheet" prompt
Hi All, I'm a noob, trying to do a basic vlookup (or match, don't care), but when I start the formula, there is no "Reference another sheet" prompt, as I see in every single help video. I've tried directly typing in the name of the sheet/table, but it's not producing. =VLOOKUP([Contract Name]@row ,{List of…
-
Sum for a Coloumn based on Multiple column categories.
I have this meta data sheet that shows all the information from a form being submitted, and im trying to gather sums of specific resources based on their qualifiers into another sheet thats easier to others to read. Example would be I have a resource that has multiple configurations and im trying to separate those out…
-
Row-wise Reports of Sheet Summary data
Hi It would look much more elegant if the sheet summary cells in Smartsheet reports could be displayed in a row-by-row format, rather than just the current column-only layout. I feel this vertical arrangement, as shown in the attached sample image, would create a cleaner and more appealing presentation.
-
Form for many parts at once
We have a form that a technician fills out when a part breaks. It then send out auto update to parts department to fill out the price of what the technician enters. However sometimes there are many parts that needs to be replaced on one machine.What is the best way to make the technical be able to fill out the parts for…
-
How to create a master contact list to keep sheet contact lists up to date
Is there a way to use an export of User List from the User Management list in Smartsheet Admin Center to create a master list that can be used to automatically update Contact List columns with a common column name and function across many sheets? Right now, I am manually keeping individual sheet contact lists updated as…
-
Cross-sheet reference option not appearing in formula editor (Pro plan)
Hi, I’m on the Smartsheet Pro plan. In one sheet I have a column called Status (with dropdown values such as “Building permit received”). In another sheet, I want to count how many rows have a specific status using COUNTIF. According to the pricing page, cross-sheet references are available on Pro, but when I type…
-
Find missing/deleted scenarions
I have 2 sets of scenarios. The first set is a full original set. The second set has been modified, some scenarios might have been deleted. How do I determine which scenarios were deleted between the full set and the modified set. Each scenario does have a unique scenario ID. If possible, I would like to determine the…
-
Consolidate Sheets without Formulas and Functions
Good day, I have 7 sheets that are filled with data and formulas. They are 7 separate sheets because there are so many formulas running that I have maxxed out Smartsheets capability to function on one sheet so I have had to split each sheet by location. How can I consolidate ALL of these sheets into one single sheet…
-
Form URL based on selection
Hey team, im trying to wrap my head around the file upload limitation on the form. The current limit is 10 files, which is very small. Im thinking of a workaround to send the user to another form after first form is submited for extra uploads. However, I cant figure a way to pass a selection from form #1 to Form #2. On…