-
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.
-
Expiration Date and Symbol Formula
I am looking for some help on a formula. I would like for if ANY of the dates are expired, put 'No' (red circle) in the row; if ALL of the dates are not expired, put 'Yes' (green circle) in the row. Below is a snip where I have entered the symbols manually to show what I am after. Is this possible?