-
Time entry form
Hello, we have a sheet for our trades to track their time. We have one user who can't enter time in half hour increments when filling out the form. He seems to be the only one with this issue, everyone else can enter in 0.5 increments. We have it set as a text/number for the column type and display as a single line text…
-
Underlying row sort logic
Can you help me understand the underlying logic of how the rows are sorted and why it changes? My understanding was that the rows were supposed to stay sorted once we saved the sheet until someone else changes it, but that's not the case. I'll be messing around in the sheet in the middle of the night when no one else is…
-
Share a report with a collaborator that is not shared with the underlying sheet
Hello, I am in need of sharing a report from an underlying sheet, however the user I would like to share it with is not shared to the sheet. Besides sharing the sheet or creating a new sheet, how I can share the report? Thanks, Lara Lehnerz
-
Copying data from Summary Sheet to another sheet
Hi, We use the summary sheet of project plans for PMs to update the overall RAG and add any specific comments about the project and it gets pulled to Dashboard for reporting. However, I am also trying to create a repository of "overall status RAG" to observe if there is a trend over the life of the project. To do this, I…
-
Help with workflow
Hi, I've created a workflow from the "Alert someone when specified criteria are met" template. The trigger is based on a selection from a dropdown list that will send an approval request to certain managers. The issue I'm having is that there are over 30 different selection options in the list. Do I need to create 30…
-
Automation to updates all with same name in the primary column?
Hi, I primary columns with customer ID's. I have date columns I put today's day in when I have contacted that client. What I need is, when I put a date in the date in the column, is to have all the customer with the same ID in the primary column to have the date column also fill. Or a help column auto fill with a text or a…
-
Power BI Issue Integration with Dashboards
Hi, I shared and copied my Power BI dashboard link and I get an error. Does anyone know what's triggering the error ?
-
How to resolve " AttributeError: 'Error' object has no attribute 'save_to_file' " error?
I am trying to print a calendar to pdf using the API and am stuck on using the "get_sheet_as_pdf". I attached the code below that I used and am getting the titular error, I went into the sheets.py file to see if I was missing something but there doesn't seem to exist a method "save_to_file". Also, is it possible to ensure…
-
Reporting against parent and child rows
Good morning, i use Smartsheet as a project tracking tool. using a parent row as the project name and then various child rows to detail the actions required. each action is allocated to a different member of staff. i would like to produce a daily report for each member of staff showing todays actions, but i need the action…
-
Smartsheet reports created from 1 sheet for updating, need to allow users to set their own filters
Hi, I have a Master Smartsheet, that I created 20 reports from. Each report is a filter for each user and shows just the columns that need to be updated. As we add add more data by phase in the master sheet, each user wants to filter the data by phase as they are working through their tasks. Edit permission does not allow…