Forms and Blank Rows
Hi,
We using a Smartsheet form to capture Covid19 Screening Questions. Once submitted the person has their temperature recorded which is manually captured against the record.
The problem I am experiencing is that the person capturing the temperature sometimes accidentally inserts a blank row into the sheet which results in the formatting being lost in subsequent form generated entries.
Is there a way I can prevent a user from inserting rows in a sheet when they are still required Edit rights to update one column?
I have tried to create an alert based on a blank "Entry Status", however this is not working as Im guessing Smartsheet is not recognizing the empty row
Thanks in advance for you assistance and looking forward to your suggestions.
Many thanks
Lyn
Answers
-
In addition to the above, I did consider a creating a report where the user can capture the temperature, however the reports do not automatically refresh as the sheets do and we are receiving multiple submissions every minute.
-
Could you use an Update Request automation to send to the user to capture the temperature. That way they don't need to access the sheet at all?
Just a thought...
Debbie
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!