-
Select a cloud service folder for attachments
I would love to use something similar to the existing Box, One drive, etc, integration to be able to select a whole folder to attach rather than just individual files. When a new file was added to the folder in Box, it would also be available in smart sheet.
-
Sheet Column References in Equations
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get…
-
Gantt Report for Several Sheets - Can I drag & drop dates in the report?
I would like to be able to drag & drop Gantt dates in my report as we have several projects going concurrently, and the report is great for big picture. How do I do that? Also, how do I reflect a pause in a project, as in we're waiting for info from a client but are working on other jobs in the mean while? I would like it…
-
Sorting tasks then go back to original layour
I have several projects i keep on one sheet. I would like to sort them by due date, update items in the most pressing and return to my original nice layout that has all of the projects with headers and then the items to work on under each heading. Whenever I save a change after sorting by due date, I cannot get the…
-
Human Resources Time Off Requests with Functionality
Hi, I found 2 templates on smartsheets for time off, but neither work, and I have attempted to customize to my needs and I am not able to figure it out. First I want a form that employees can submit their leave, Second create a workflow for approval, and Third be able to tally the balances automatically to the appropriate…
-
Reminder Notification Emails
Is there any way to customize what columns I see in reminder emails? We had a client which recently took control of a worksheet we've been using and I no longer have admin rights. Before, I had made a "dummy" conditional column to change when needed, then I would send myself a nice clean Notification. So is there any way…
-
restrict users from editing curtain fields
Is there a way to restrict certain users from editing curtain fields? For example, we are using Smartsheet so users can enter info waiting for approval, but we want only admin should be able to mark off "check box" for approvals.
-
OFFSET FUNCTION
Hi SC, Does Smartsheet have an equivalent of the EXCEL OFFSET FUNCTION ? Thanks
-
Link to cells in a different sheet
Hi SC, I need to link cells across two different sheets and I am looking for a way to avoid having to create the link one by one. The cells to be linked are located in adjacent columns so ideally, I would just need to create the first link for the first column and then drag the formula through all the columns. I tried it,…
-
Sending out sheets automatically
Let's say I want to send out my schedule every Friday to a few specified emails. Can I set it up to do this automatically?