Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formulas Dissappear
Is there a way to keep the formulas from dissappearing? I have a formula set to check if the checkbox is checked but if the checkbox is checked independently from the main checkbox then the formula seems to dissappear.
Also, is there a way to view the form as another type of user, ie...viewer, or editor?
Thanks
YouTube of the issue
Comments
-
Hi Russell - checking the box will replace the contents of the box with the check, the same way the content of a text cell will be replaced if you click in the cell and add text. One reason for this is if the formula remains, it would contradict itself (formula says to uncheck the box, but the box is checked).
If you remove a formula from a cell because you added other content to the cell, you can drag fill the formula from the cell above or below to quickly add the formula to the cell.
-
That is what I needed to know. Thank you.
-
Russell,
To answer your last question, see this article on user privileges.
http://help.smartsheet.com/customer/portal/articles/1155182
I think by design the WebForms are meant to be used for inputting data ... so having a form that was view-only is likely a feature request.
http://help.smartsheet.com/customer/portal/articles/522221
Travis and other Smartsheet developers monitor the Community looking for input to the development. You can also email support@smartsheet.com
Hope this helps.
Craig
-
Thanks Craig, I missed that last one!
Craig is correct, web forms by design are used for inputting data. If you want a view only version of a web form, you could take a screenshot of the form, then distribute as needed.
If you want a user to edit the contents of a single row, try using update requests: http://help.smartsheet.com/customer/en/portal/articles/504779-using-update-requests
You could also lock all your columns or selected rows, then send out an update request which will show all the content but will be read only (locked columns/rows cannot be edited in update requests)
-
Travis, you are welcome.
That last one about locking columns prior to an update request is a great idea.
I hadn't seen that one before. Cool!
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives