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

12/29/15 Edited 12/09/19

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?




YouTube of the issue



  • TravisTravis Employee
    edited 12/29/15

    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. 

  • J. Craig WilliamsJ. Craig Williams Top Contributor
    edited 12/30/15



    To answer your last question, see this article on user privileges.




    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.




    Travis and other Smartsheet developers monitor the Community looking for input to the development. You can also email [email protected]


    Hope this helps.





  • TravisTravis Employee

    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)

  • J. Craig WilliamsJ. Craig Williams Top Contributor
    edited 01/04/16

    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!



This discussion has been closed.