-
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…
-
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…
-
Feed line from one sheet into another multiple times, assigning a different task to each new line
Hello! I have a master sheet where I keep track of all of our companies' giveaways we offer. It has a lot of checkbox columns to identify which tasks have been done and which have not. Currently I have automated reminders set up that send me an email to tell me something needs done. However, that A LOT of emails, and I…
-
How can i use IF, AND in a date formuls?
I currently have a formula that looks at a column called "Week #" and takes the entry and converts it to a date that represents the first monday of the corresponding week. This helps me plan work a number of weeks out. the problem is that as i get towards the end of the year, i need the date produced to show the week for…
-
Recreating the Countermeasure and Task Spreadsheet
I am having problems recreating this sheet where multiple users (without logins) can update their project notes weekly on any progress made. I want it to associate the Countermeasure - Project - Task. I want to tie it to a A3 Dashboard (for each project showing the amount of task/ projects completed, inprogress, etc.