We have created a form in Smartsheet and noticed that Smartsheet automatically adds blank rows between the last row containing data and the row created by the form. How do we prevent blank rows from being added?
Hi @Liz_Snavely , I have had a similar issue before, I believe this happens when users inadvertently use the rows. Despite them looking empty they do hold some data.
When I was looking at this, I established the rows had been used by adding the automated created by column which indicated that they had been used at some point. In my case the rows values were removed, but the row was left in place, when the import from the form happens, it adds the row at the bottom of all existing rows.
After removing the extra rows that were left blank, my form added the rows correctly directly under the previous entered rows.
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Hi, I have a sheet that collects data from several forms. I have an automation that kicks off every Thursday at 5:00 AM to move all the data in the sheet to an archive sheet, I have another automation that is supposed to kick off at 8:00 on Thursday to check if the column is blank, then alert someone via an email to enter…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.