-
Navigating to the source sheet from a report
I cannot find a way of navigating from the report to underlying source (apart from sheet name column, which messes up with the presentation - so I typically remove the column form the view). Plus, having the sheet name on each row is annoying. So in few other instances, I grouped a multi-sheet report by sheet name. The…
-
Report not showing Data when a second sheet is added
Hello, I have a report that displays data properly but as soon as I add a sheet, my data vanishes from the columns before I even add any columns from the newly added sheet. I searched for a similar question but those issues had to do with filters but I have none. Why do I lose my data when I add my new sheet prior to…
-
Is there a way to use a form so that it creates a parent row with children rows when it's submitted?
I'm wanting to create a Purchase Order Request Form that when submitted it adds a parent row to a sheet identifying the new purchase order and then has a child(ren) row(s) underneath with the details of the items being requested, kind of like this PO Log Template I found here:…
-
Report Glitch?
Has anyone ever seen a glitch with a report? Maybe its user error lol. I have a report with the following filters However, for some reason it is pulling a line with an end date in March. There is also a sooner date in January that it is not picking up (I wouldn't expect it to since its not in the next 14 days). Any…
-
SmartSheet Splash Screen
Hi I believe the answer is No but wanted to check. I have published a form that we would want to have our external customers to complete. Prior to showing the form, the SmartSheet Splash screen is shown then the form. Is there a way for the splash screen to be disabled?
-
prevent owner from editing locket cell
how can I prevent owner to not be able to accidentally edit a locked cell/column, columns are already locked, but the owner will sometimes accidentally edit cells with formulas. Be nice if there a way to disable the accidentally editing. at least if there was a warning that could be enabled to warn the owner about editing…
-
Automation trigger to move all cells in grid to anther grid when triggered by data in one cell.
I set up a grid to gather information for a 50 can check. We do these checks randomly throughout the day. So I need the data from the last check to stay in the grid until a new check is done. I set up a trigger to move cells when a cell has a certain data like 1st check, 2nd check, or extra check to move cell with the…
-
How to Send Timed Reminders Based on a Trigger?
Hi, everyone; first post, Intermediate user. I'm hoping you can help me. I've set up a SS to send an approval request when a new line is added to the sheet from a form entry. I've got the automation figured out for approval or declination. I'd like to send reminders if no one answers that approval, though. What I'd like to…
-
Have cells inherit background color
So, I have a helper sheet that tracks Budgeted, Committed and Actual spend for an individual project based on the end date from a project sheet. The sheet is laid out where a total of 24 months have their own columns in chronological order from left to right. There are four rows for Budgeted, Committed, Actual and the last…
-
Calendars
Hello! The company I work for does not have the Calendar App in their plan (at least not for now), so can anyone share their best calendars tips and tricks to show their Holiday staffing without using the calendar app? Any and all suggestions welcome! Elizabeth aka Smartsheet's #1 Fan 😅
