-
How to Automatically Update Rows in Smartsheet Based on Another Sheet?
I’m working with multiple linked sheets in Smartsheet and need certain rows to update automatically when data changes in a source sheet. I’ve tried using cell linking, but it's manual and not scalable. Is there a way to automate this using formulas or workflows within Smartsheet? Would love to know how others handle this…
-
Sheets to Workspaces - Permission Help
Since Smartsheet no longer allows the creation of new folders in Sheets, I reorganized all of my items previously in Sheets into Workspaces. I deeply regret this, as I'm now having tons of permission issues with items I've shared with coworkers. I need to share some items with one or more people, but I do not necessarily…
-
Workspaces takes up a section of my screen
Hi Smartsheet, Workspaces takes up a section of my screen and I'm not able to scroll all the way wide right when the Workspace panel is open. Please allow me to continue scrolling to view all my sheets's columns. Thanks, Eric
-
Is there a way to copy what is in a row to another row if they are the same task?
Hi Everyone. Thanks for looking at my question. My manager has a sheet with 900 rows for collecting evidence. The problem is that a lot of rows have the same Task(Column) so instead of having to input all 900 individually the sheet will duplicate the ones that have the same task. Is there a way to do this?
-
Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
-
Need Formula with nesting IF's help
Hi folks! Brand new to the community and this is my first help request. I've watched many you tube videos and read as much in the forum as I could about smartsheet formula's, but I just can't figure out what I'm doing wrong. Let me set this up for you: I'm trying to take names from a column in sheet 1, and convert them to…
-
Automation to copy row at specific dates
I have a sheet that I would like to automatically copy rows (with triggers) on specific dates. Does this mean I need to create an automation for each date?
-
Grid View - Default Values
Hi Everyone, thanks as always for your help! I have a quick question on the best way to apply default values when adding a new row to a grid view. The idea is that if someone enters a new task name, then the priority and status column for the task would automatically update to "Medium" and "Not Started" respectively. Then…
-
Using =MAX( to get latest date on Dashboard
HELLO! I am trying to get the very last date on a sheet to display on my dashboard. I am using the MAX function to return the date but I keep getting an error…..I have tried the below =MAX({Target Complete}) ….this returns #INVALID COLUMN VALUE =MAX({Target Complete}:{Target Complete}) ….this returns #UNPARSEABLE…
-
Creating a dashboard chart to represent the star symbol feature
Hello! We use the star symbols as a column in our project schedule to show the status of the project. I need to create a chart that shows graphically these statuses but have been running into many issues. To help, I created a column in the schedule that is automatically populated with the number of stars for that row.…