-
Print PDF Choose Columns Function Went Missing
I use this function quite often. I want to export a PDF document which contains selected rows. When I used to do that, I get an option to specify which columns do I need to include in the PDF. Now I am unable to do so. It looks like this option disappeared from the menu
-
Status of Child rows
Hi I am trying to create a Project Schedule with Budget and Variance and include an overall status using the status of the child rows. I have 1 line that is the overall project and then 4 phase lines, with around 20 tasks underneath each phase line. I want the phase lines to give an overall status of the child task rows…
-
IF Function with Checkbox
I'm trying to create a formula....If the checkbox is "checked" in the Toledo column, then display the formula result that's in the price/ft column. If the checkbox is not checked then price/ft column is blank. Any help is appreciated. Thx Joe
-
Multiple selections from drop-down list, enhance database function
I saw this in a thread from 2015 but wanted to re-start it. Would love the option of being able to select multiple items from a drop-down list. This is handy for improving the database functionality. Many times I have sheets with dozens of projects/rows, and I need to list multiple values for a single attribute, then query…
-
Complicated formula help
Hello, I want to create a formula that changes the unit price to half price when the quanitity goes above a certain amount - ie. Columns [Quantity], [Unitprice], [Total] - I want to charge the normal unit price for up to a quanitty of 24, when the quantity is over 24, then I want the quantity that is over and above 24 to…
-
Past Due Formula Help!!! - IF / AND
I cant seem to get the formula correct for this scenario: If "End Date" is Past Due AND "% Complete" is NOT 100% = "Complete" to turn flag red in "At Risk" column Am I correct that the formula would go in the "At Risk" column?
-
Unique numbers in a column
I have a sheet that we add rows to everyday. One peice of data that is added with every new row is a case number (unique identifier to show us who we are working on). How can I get a total of unique case numbers? I simply want a count of all case numbers no duplicates. So if case 12345 is on my sheet 5 times I only wanted…
-
Update requests
Hi everyone, I have built a sheet in smartsheet to track supplier performance. When there is an issue with their performance, I am wanting to send the supplier a update request in order for them to provide corrective action for problems and it to be written directly into the sheet. This works great but to provide context…
-
Persistent Theme: Restricted Sharing. We need an update on this
Smartsheet, Smartsheet solves so many problems evident in other project management and collaboration software. However it is critical that Smartsheet be able to limit sheet access to owned rows based on contact column information, or that Smartsheet add the Contact Column and a "pull" mechanism to the Update Request…
-
Conditional Formatting on Web Forms
Does anyone know if there is a way to implement conditional formatting on web forms? For example, if I have a web form to populate a sheet, I want to be able to implement rules to email certain people based on a specific value selected in a drop down on the web form. I did try to figure this out using Zapier, but couldn't…