-
Automation Issue
I set up smart sheets for different districts and we have 2 reps who are not receiving assignment ownership. Has anyone run into this issue?
-
2 forms within one sheet
How can I attach a form to an automation? I have 2 forms within my sheet. Form 1 is the main form that generates the lines into the sheet. The automation is an update request where they will need to fill out this form 2, but how do I make that possible in an automation? Once they do fill it out, where in the sheet will the…
-
Report Grouping Issue
I have report that summarized about 38 sheets using sheet summary fields. For some reasons, one of the fields isn't coming through so the report is not grouping properly. It's only happening for a few sheets but it's the third time it's happened this week. To fix it I have to go in to each sheet summary, take a letter off,…
-
Chart Data
Hi Smartsheet Team I have tried to add my metrics sheet to make a chart but it keeps saying "Selected data cannot be charted." Please see below. I want to pull out the Services Events and Programming sessions to make 2 charts. Your great help on this is highly appreciated. My data sheet is like this.
-
Displaying a Deck instead of the GSlides on Dashboard
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
-
Copying from Excel that has hidden columns
Hello Community, I'm facing an issue when copying from an Excel document with hidden columns to a sheet that has the exact same columns, but none are hidden. When I use Command C in Excel and Command V in the sheet, it only pastes the Excel's visible columns. Users have to transfer specific rows from excel documents into…
-
Formula to get a percentage of a column and for it then to show up on a dashboard.
I am very new to this, so this is a very basic question. I have sales numbers that will be entered on a monthly bases. I need a column that will show the how close they are to their goal amount, which will then show up a graph on a dashboard. These numbers will be coming in by a form filled out by the client. The sheet…
-
"When rows are added" not triggering Update Request automation
I have setup a project intake process that allows the user to submit an Excel spreadsheet via Smartsheet Forms. Data Shuttle extracts the information out of the spreadsheet and adds to my Project Intake sheet. I want the department leader to be able to approve or decline the project and to assign a PM to it. I setup an…
-
Percentage formula
I am trying to get a percentage of admin from the total hrs logged in the individual utilization collumn using this formula but it is not working. =IFERROR(Admin@row / [Total Hrs Logged in]@row, "") please help.
-
Discrepency in Total Float in print and the main sheet.
Good day, Today, I encountered an unusual situation when printing the Task Sheet. Please find attached copies for comparison. On the main sheet, the following activities 22, 24, 26, 27, 29, 31 all fall under the critical path, which is correctly displayed as 0 total float. However, upon printing, the same 22, 24, 26, 27,…