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.
Discussion List
Booleans
I need the formula for counting the checkboxes in a column.
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…
Lock column in report
How can I lock a column in a report? When I right-click a column in a report, I don't see the "Lock column" option.
Login history non-licensed users
It seems that it's only possible to review login history of licensed users. We have a relatively small number of licensed users, but we share project timelines with many external stakeholders (with view only access). It would be great if we could somehow track their level of engagement in our project timelines, possibly by…
Create an update request for a single row, and send to an email listed in that row ?
I have a contact list with 500 rows, one for each employee, that requires constant updating as staffing changes. Is it possible to create an update request for a single row, and have that request go out only to an email address listed in the row, permitting each user to view and update only their own information in one row…
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…
Using a template multiple times in a sheet?
Hi I need a series of 8 lines (template?) repeated within a sheet along with any discussions/attachments. These lines would be added at various times throughout the year as required. I do NOT want to use a template to create a new sheet with my required lines....just to be able to add to existing sheet. Any thoughts folks?
Wrong sorting order with numbers smaller than 1
Hi there, we are using a column "Estimated work in days" with a DropDownList with the values: 0,25 0,5 1 2 5 10 n.a. t.b.d. Please consider "," here in Germany is the decimal separator. Sorting the rows in a sheet leads to an order were rows having 0,25 or 0,5 are listed below (or on top) of t.b.d. In reports the sorting…
% allocation
Is there a way to get %allocation to be set to zero for people once a "completed" checkbox is checked?
hyperlink to an address on our network
Is there any way of using an hyperlink to an address on our network. Possibly a third party app?
