Sign in to join the conversation:
I have a report pulled into my Sight. It's pulling in a number of blank lines along with the correct data. It causes problems when I want to sort alphabetically because all the blank rows are on the top. Any ideas? Thank you for your time. PC
Smartsheet automatically adds blank rows to your sheet. But sometimes those rows gather data (like formulas) that you've added. Try deleting all of the blank rows in your sheet, saving, and then run it again.
Thank you! Yep, I have lines below the data that include formulas. I figured that might be the problem.
You're welcome!
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…
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…
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…
