-
Resetting AUTO NUMBER count in column
I tested the AUTO NUMBER column setup in a sheet to see how it works. After deleting the column and entering a new one with the proper setup, the sheet is continuing to count starting from where the previous (deleted) column left off. So, instead of starting from QUO-0001 it starts from QUO-2467 as in the attached…
-
Automation - triggered within a set number of days before a date
Hi everyone! I need to set up an automation that is triggered within a set number of days before the date listed in a date field. I need the automation to send an alert email to a new hire at most 7 days before the start date. I know I can set the automation to send 1 week before the start date, but if the new hire's…
-
Linking Auto# Columns
I have 2 sheets that I need to link: Sheet 1 - collects user registration information through a form. Sheet 2 - I want to link some columns to copy partial data collected in sheet 1 and have it show in sheet 2. I don't want to copy the entire row, just select columns and I don't have Smartsheet Bridge. Each sheet has a…
-
Graph Question
Can someone tell me how to get rid of the 120.0% max on this graph? It is always going total 100% and never any more, so I would like to use more of the space for graph display purposes. I even tried reducing it so that the largest value was 99.999%, thinking maybe being exactly 100 would cause the next "level" to…
-
Intermittent failure of selected Smartsheet automations
Hello, I am experiencing an issue with automations in Smartsheet. Some workflows continue to run normally, but others stop working intermittently even though they were previously functioning as expected. The issue does not appear to affect all automations, only certain ones. An important detail is that when the affected…
-
Android app not syncing with web or windows app
The Smartsheet app on my Samsung phone (android) is logging in perfectly and showing all my sheets etc, but when I try and log in to my account on the web or windows app it says I have a trial account and now sheets are showing - what am I doing wrong, is there someway I can get them to sync with my android app??
-
Columns rearranging
Hello, I want my ~50 columns in my sheet in a certain order, however after rearranging several times, the columns move out of order. I do have a sheet connected to this sheet by a move automation, but I also rearranged those columns in the exact order as the first sheet. How do I keep the columns in the specific order?…
-
What's breaking my task dependencies when using elapsed day duration
Hi I ran into an issue today where my smartsheet timeline was updated without any user's input and several dates were changed cascading to the entire timeline. I tracked it down to several tasks and started correcting them, realising that there is some issue when dependencies are using regular "day" duration and some are…
-
"File Didn't Attach. Try again"
When I try attaching files to lines on Smartsheet, I'm getting the error message "File didn't attach. Try again." Does anyone know of a solution?
-
Copy Row Automation Not Working
Good day, I have the above simple automation to copy a row to another sheet when a specific checkbox is checked. I am having two issues: The automation does not run when the box is checked When I run the automation manually, all the rows in the first grid, are copied to the destination grid. How can I fix the automation…
