-
3 base files with confidential infos in a combine master file
I have 3 different sheets. Each sheet if filled out by a factory and I would like to summerize the content of this 3 sheets in a master file. The factories are not allowed to see the content of the other sheets (A,B,C, Master) only their own sheet. The master file is shared with other people than the base flles (A;B;C).…
-
How can I have the results of two different forms populate to one sheet?
I have a sheet called Event Sheet. There is a lengthy form associated with this sheet that allows submitters to request rooms for a specific date / time, etc. It also allows them to request media, room setup, etc. I duplicated this form and created a 'short form' and took out many of the inputs so folks can just request a…
-
Lines of my Smartsheet are Archiving in error
Good day, I am having an issue where some of my lines on the Smartsheet will automatically move to the Archive sheet without my checking the archive box. We have our sheet set up so that if we check the Archive box it will then go over to our Archive sheet. But, it should not leave our active sheet unless this box is…
-
is there a way to view a sheet in the same window as a "modern" theme form?
I have a form, using the modern theme, that requires the user to enter a unique numerical code associated with a project, as part of the project's approval process. Is there a way for the user to see the sheet (or part of it) that contains the list of these codes, so that they dont have to go searching around the dashboard…
-
Does anyone know a way for tracking quantity deduction when it comes to material requests ?
I have been trying to track via the activity log on the right hand of the sheet, however the reports are taking too long to produce. I just need something that i can send to the accounts team that shows how much material was used in a week. Please let me know if anyone has a solution. Thanks, Brendan
-
Smartsheet Card view- group by within a kanban
Hi! I want to be able to group cards in kanban view for an ongoing meeting. I still want the statuses of To Do, Blocked, In Progress, and Complete but I want to add a group for categories in our department so we cover cards in each major area first. This is available in Teams Planner as a Group by feature. Does Smartsheet…
-
Can a Smartsheet form populate a PDF, and then send that PDF to Slack
Hi My company has a logistics driver that delivers sets to theatre. He usually fills in a paper form of what he has dropped off and then takes a picture of that and posts it on Slack. We have decided to move over to a paperless system and have made a smartsheet form to track which sets are delivered. Each time a new row is…
-
Importing Excel Sheet
Hi , If I add an existing Excel sheet that has VBA coding to import info from another document, will it still work once it's imported into Smartsheet or will I have to re-import it each time there is an update. Thank you!
-
Changing multiple row on app
Hi All, So we use smart sheets for controlling where parts are kept. we might have a box of 20 parts that all have their own row which has a barcode on it. We then put a box number against all the rows. When we move that box i want to be able to change the "location" cells to where the box it. Ie in the workshop or at a…
-
Calendar as default view when shared in Teams tab
Is there a way to ensure a Smartsheet imported to Teams always displays in Calendar view? I think I have been able to save this view as the default in Smartsheet itself, but when I open the sheet's tab in Teams it displays as grid view. I signed out of Teams and signed back in to check whether the changes just needed to go…
