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

https://youtu.be/WWXox7vKcXk

Find more posts tagged with

Construction

Formulas

IT & Operations

Comments

Travis

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.

Russell Stanford

That is what I needed to know. Thank you.

J. Craig Williams

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

Travis

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 Williams

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