-
Sheet summary report not showing all columns
So i was trying to edit a sheet summary report that was built from someone prior to me and i was struggling to make the necessary changes so ive made a new summary report, however, i am running into the same issues. For some reason the column options in the sheet summary report are not all of the options that should be…
-
How to count criteria in a multi-select column
I have a sheet that tracks the priority level of funding requests and I am trying to formulate a metric that 1) counts the number of requests under a particular priority level and 2) only counts the request if it is under a particular Division Group. The issue I am running into is that the priority levels are multi-select,…
-
Chart widget not graphing dates correctly
I am trying to graph the costs spent on projects per month in th dashboard using the chart widget. The problem is when the project goes into the next year instead of setting the first months spend ahead the last month in the last years spend it moves it to be next to the same month in the previous year as seen in the…
-
Document Generator Quit Working
My document generator on 2 of my sheets just stopped inputting the data into the PDF forms. It will name the file correctly using one of the data fields but won't put the data in the file anymore. I remade my form and the automation like 10 times! The file is small, sticker size 2.25 x 1 and has a barcode font on it. This…
-
Return latest value from another column's latest rows
Hello, I have a sheet in Excel I'd like to move to smartsheet to work with a client's team. The only problem I have is with the fields "Previous Cumulative Partner Discount" and "New Cumulative Partner Discount" as they have formulas that involve each other column in theirs and in Smartsheet it returns the circular…
-
Linked cell not working
I have linked my plan cell with another cell from another plan (it was task status btw), so it will serve as reference for my plan when my dependency task is complete, I can proceed with my tasks, but the content of this cell is not updating (the other links I did worked). What could be happening? thanks.
-
Export selected rows only to excel
Hello, is it possible to export only the filtered rows to excel? When doing the export, it will hide the rows that were filtered, but they will still be in the excel so if I try to copy and paste or create a mailmerge, the excel will also pick up the hidden rows. Alternatively, is it possible to do a mailmerge via word…
-
Smart Sheet Use for Project Management - Meeting Agenda (w/ Form) to Action Item Tracking (Per Proj)
Hello everybody, First time poster. I've searched the forum to find a solution, but I wasn't successful, so decided to create my own post. I'm new to smart sheet, so would appreciate help in getting a solution for my workflow. Just as some additional information - we currently have numerous live projects at any one time,…
-
Collecting time range in form
I'm creating a form to collect the days and times that employees will be out of the office so that I can get the info onto a dashboard for the team to refer back to. Since Smartsheet doesn't have time fields for forms the best workaround I could find was using dropdown fields with half hour time segments and have one field…
-
Workspace Panel Auto-Opening
I know this topic has been addressed previously and was resolved but is now happening again. Is there a way to disable or remove the workspace panel from auto-opening each time you open a sheet? It's extremely frustrating!
