Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for March 2016
Discussion List
Booleans
I need the formula for counting the checkboxes in a column.
conditional symbol
Hello, I would like to know if it's possible to use a symbol linked to a result. For example: good result (up arrow) bad result (down arrow) automatically Thank you
Formulas
I have two cases where I need a formula to work for me The first one is easy. I have two columns - Delivery Date and Delivery Date (2). I want Delivery Date (2) to automatically put the same date that is in Delivery Date in the corresponding cell. I tried =[Delivery Date]1 but I get an error that says #number expected.…
Setting a project due date, then building tasks with predecessors leading into it - not working righ
I know there is a way to do this but for some reason I am stuck. I have an event taking place on 5/25. So that needs to be the due date and it CAN NOT MOVE. I then have maybe 40 or so tasks leading up to it, all of which have to occur in certain sequences. I am not able to set up the project. One of two problems occurs.…
Generate Report per Row
Is there a way to generate a report per row? I have one project for each row with numerous columns. I would like to create a one page report that list the columns in a vertical format with the data from its corresponding row. Does that make sense?
Batch Email Reports
Despite my best efforts I can't get some folks to log in to SmartSheet and access the reports themselves. They want the PDFs emailed to them. To cut down on the number of emails they get, I'd like to set up a recurring email that contains more than one report. Is this possible? Thanks.
How can I automatically capture date of entry on form
Hello - I've setup a webform for users to enter information about potential participants in a program. I want the form to automatically capture the date when the form is completed. I had initially set it up where I established a date field on the form but hid it from users. I thought by selecting 'Today' from the drop-down…
% allocation
Is there a way to get %allocation to be set to zero for people once a "completed" checkbox is checked?
Help with an IF statement
I am trying to get the R/Y/G/B status to change based on some other cell values and am using this =IF(([End Date]17 - TODAY()) < 1, "Red", IF(([End Date]17 - TODAY()) < 5, "Yellow", IF((ISBOOLEAN(Complete17)), "Blue", "Green"))) The first part works fine. I wan the icon to go blue if the "Completed" checkbox is checked but…
Smartsheet won't save changes after a sorting
This morning I did a sort on one of my columns so I could review and enter data easier. When I went to save the data Smartsheet told me it couldn't and to save data more often. I tried doing the sort and then saving after the first number update and I got the same error. The only way I can save my changes is if I don't do…