-
Update Request: How to set permissions on cells?
Currently, when sending update requests to partners, the respondent can see AND edit all selected cells in the row. Is there a way - or a plan for such functionality - to allow respondents to the update request to see certain cells, but only edit specific cells (maybe this would be an additional checkbox or the next step -…
-
Drop Down Notifications
Hello, I would like to create a sheet for employee onboarding. In that sheet I want to have drop downs for supervisor names. I would then want the smartsheet to email the supervisor that was selected. Is there a way I can do this?
-
Send Update Request
Hello All I want to share an exciting SS discovery! I am currently doing the Smartsheet Project Management course. The send Update Request function will truly transform my work life. This option does not require the person being requested information to log into smartsheet to answer the specific questions I require…
-
Export comments based on date criteria with primary as label
Requirement: * 1. Ability to filter comments by date range for export - for example today's comments associated with the rows on a specific report * 2. Ability to display primary field as a label in the exported comments We use smartsheets to manage tickets. When we hold a meeting, the above output would essentially be the…
-
Email to smartsheet for helpdesk
Is it possible to have an email sent to a smartsheet. I want to use smartsheet for helpdesk, however it would be nice if users could send to an email account sometimes besides updating a webform.
-
Using COUNTIF and MONTH() to Find a Specific Date
Hello: For a given set of rows with due dates: 04/03/17 04/28/17 04/03/17 04/03/17 06/01/17 04/03/17 05/17/17 05/17/17 04/28/17 I need a formula that will count up all those due in April. I am working with the following formula, but it is not quite right yet: =COUNTIF(DueDate:DueDate, @cell MONTH(DueDate:DueDate) = 4) Can…
-
Automate RYG Ball based on Checkboxes in Other Columns
I need help from the SmartSheet formula masters... I have 10 checkbox columns (checkbox) and I want the RYG ball to automatically change with the following conditions: * 1) "Red" if no checkboxes are checked. * 2) "Yellow" if some checkboxes are checked. * 3) "Green" if all checkboxes are checked. with one exception... if…
-
Excel rows
how do you get around this limitation??
-
Change next row status when previous row status is complete
I have multisteps to complete an order, Since start of many steps is dependant on the completion of previous steps, Can I program that if a previous steps say row 1 and 3 are complete (status Green), next row status changes to Yellow. I did this by giving code to each row and then with IF statement (If Code of row 1 and 3…
-
Loading files to form or sheet
We have have created a form to allow anyone to create line in a sheet and attach corresponding documents top that line, however it is only allowing 10 files to be loaded. Is there a way to expand the number/size of files allowed to be uploaded via the form? Or is there a way to allow view only users to be able to load…