-
Text Wrapping is not working.
Hi, I've created a new sheet and a form, I've applied text wrap to the columns that might need it and I've tested certain cells, inputting more text than the cell than would be visible. I've clicked an unclicked the text wrap button on the menu... nothing is happening. I've saved and refreshed the sheet...still no text…
-
Starting with a Sheet, that Now needs to be a Gantt - how does one get roll-up summary info
We started with what we thought was going to be a simple sheet that has grown and now had Target Start and Target End date columns. Now we look at is as a Gantt (again not started as a Gantt sheet) So we made parent and child rows, have the settings in Gantt view looking at these date columns. However, if you indent/make a…
-
Can we create multiple dynamic views from the same sheet?
I have a sheet in Smartsheet that want to create 2 different views that one dynamic view is restricted by the PM column and the other dynamic view is restricted by the Incident Advisor column. I was able to create one dynamic view, and when I duplicate the same dynamic view and rename it and change the restrict by, the…
-
Copy a Notification as an sheet attachment for a specific row
I am using SmartSheet for various Change Managment approvals, notifications tracking, and auditing automations. Is there a feature or way that when an Approve / Decline automation is triggered, the notification and response tied to the row where the trigger originated from can be saved as an attachment? We would use these…
-
Count how many with checked box
What formula to use in order to count how many cells with any of the columns checked please?
-
Circular reference error help
=IF([Cancel Request]@row1 = "Canceled", [AW Request Status]@row) =IF([Cancel Request]@row = 1, "Canceled", [AW Request Status]@row) If cancel request column is check then change AW Request status drop down to "Canceled" I keep getting error message of #circular reference
-
Reference a sheet summary field and use as a column formula
I want to assign the same project number to every row in my sheet. I want to have a "Project ID" summary field. And then have a column formula in my sheet: =[Project ID]# It works as expected (returning the Project ID) for any row I physically type that formula in. When I convert to column formula, it does not return any…
-
URL Query String with Dynamic Data Connected to QR Code?
I recently built out an inventory system that generates a custom URL query string for each item that partially pre-fills out a form to check items in/out of inventory. The form is meant to include a "current stock level" value so the person knows how much they are able to check out of inventory, but the team using it wants…
-
How to send an automation to multiple contacts in another sheet?
Sheet A has a column of email addresses, the quantity of which is always unknown (could be 5 rows today, 10 rows tomorrow) and the content is not always static as people change roles (email x may be changed to email y tomorrow). Sheet B has an automation to request an update when a row is updated. How does Sheet B sent the…
-
Formula issue
This discussion was created from comments split from: Formula won't recognize cell data.