-
Request approval
What does this mean? I am requesting approval. I need to know if they approved or declined...now submitted because idk if they approved or declined
-
How can I tick a box based on two criteria?
I'd like to tick a checkbox based on another checkbox being ticked and for a specific task name. I have the following formulas that work individually. How can I combine them? =IF([Checkbox]@row = 1, 1,0) =IF([Task name]@row = "XYZ", 1,0)
-
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…
-
Como puedo sumar datos que son generados por formula de IF ?
This discussion was created from comments split from: SUMIF Formula.