-
Date value is off of Modified Date is off by 1
Something has changed. I have a formula =[Modified Date]@row that captures the last modified date and keeps it static. I do this as I have rows backed up nightly to another sheet if they were modified. Just using Modified Date doesn't work as the date changes once it's on the new sheet. It's now rounding the date up. The…
-
Remove or Increase Cross Sheet Reference Limitations
Please consider removing or increasing cross-sheet reference limitations. I recently built a solution that would require me to manage 3-4 sheets each month for monthly audit results tracking from Joint Commission. I spent weeks building and testing and at the end had to add more questions (total of about 125 to the form.…
-
Zoom in and out
Is there a way to zoom in and out on a sheet?
-
Trying to add form submissions onto a Spreadsheet that has a column of unique randomized numbers
Hello all, I was wondering if someone can let me know if there is an easy way or even a workaround to my issue. I have a list of randomized coupon codes in a column, and I need the form submission to populate the next available row with a coupon code. The issue I have right now is that, I have the column of 500 coupon…
-
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…