-
Chart Showing Negative Numbers When Value is Zero
I have a chart that has several categories of expenses. The value of one category is zero. When plotting the values, Smartsheet's chart shows -200 on the vertical axis. Is there a way to say start at zero?
-
Copy a Hyperlink
I am trying to copy a hyperlink into a cell and it won't let me copy and paste into the hyperlink box, am I missing something? Thanks
-
Automated Notifications
I have created a SS and linked it to my main sheet. I've also created notifications for this newly created sheet, but I do not receive any of the notifications that I have set up it. The linking part works fine, but how do I get my notifications to come through from the linked sheet? I've also checked my notification…
-
How can I lock a cell that I pull from another sheet?
How can I lock a cell that I pull from another sheet? In this example will be : {Formula Table Range 9}, {Formula Table Range 11} =IF($[Week-X]1 = {Formula Table Range 9}, {Formula Table Range 10}, IF($[Week-X]1 = {Formula Table Range 11}, {Formula Table Range 12}, IF($[Week-X]1 = {Formula Table Range 13}, {Formula Table…
-
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…
-
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…
-
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
-
is there a way to get "mouse-over" text for a widget on a dashboard?
I have a dashboard with multiple forms linked to it through widgets. To save space, I'd like to be able to have users be able to hover over the form widgets and get a description of what the form is and when to use it. Is this possible?
-
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).…
-
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…
