-
Can I stop auto delete data in cell
I lost my data in the cell that I choosed it. When I select the cell that has some data for a while, text will disappear. I have to undo to get data back. I am not sure, this is only my problew or another users have it. Please fix this problem as soon as possible cause it is very unconvenience for users and has high risk…
-
How to Countif only the un-checked boxes in a column (leaving out blank boxes)
I understand how to countif the checkboxes in a column with the COUNTIF=([range]:[c],1) such as shown in this community post: https://community.smartsheet.com/discussion/counting-checked-boxes But I want to be able to count the boxes that are un-checked. I used CountIF=([range]:[c], 0) but it gave me the other blank boxes…
-
Printing Webform entry - Print Row Info Vertically
Hi, We have created a webform for Purchase requisitions in the field. We would like to print the populated form, but this feature is not available in SS. Can I request this be an added feature. We would also like to print the Row entry in vertical mode , just like the option in Send an email of row data. Regards Paul…
-
Locking a Single Cell
Is there a way to lock a single cell instead of an entire row / column? I do not want to lock the users from entering data on the entire row / column, but I do want to protect a formula(s) in certain cells.
-
Using Approvals with a formula cell
I am trying to use an approval request to change the value of a cell that contains a formula. The cell that has the formula is based on data in two other cells. For example, the other two cells can either be "Yes" or "N/A". If both of them are "N/A", then my approval cell automatically changes to "Yes" and it does not…
-
Forced dates when dependency is enabled
We are working to importa 1800 line project plan into smartsheet and have run into a dabilitating problem with the dates. What looks to be happening is that the “Duration” and “predecessors” fields are completely driving the dates for the tasks. Anything with a predecessor is automatically forcing the start date to be the…
-
Calculation Formulas on Reports
Our company uses Smartsheet a little differently than most but I am finding it would be very helpful if I could add formula calculations directly to the reports I pull. Currently I have to add the formulas to the sheets themselves, hide those columns and continue dragging formulas down as we add rows. Hundreds of sheets...…
-
Automatically transfer data entered in one sheet to other sheets.
Hello Everyone, Does anyone know if it is possible to create a master sheet, then once a row is added to this sheet, the same row (With only specific columns) could be automatically added to another sheet(s) ? Your help is Highly appreciated. Thank you, Hamza
-
Count "Yes" and Return Percentage?
I am trying to create a "scorecard" of sorts. I have seen the formulas that allow you to count the number of "Yes" and return a value. But can you return that value as a percentage of responses? For example, say I have 5 columns with drop down answers of "Yes" or "No". Assume four columns were "Yes" and 1 was "No"; That…
-
Sharing Reports without sharing sheets
We want to share reports with customers so they can see schedules but do not want customers to be able to view other customers schedules on the primary sheet. In order to share a report we must also share the primary sheet. Is there a work around for this?
