-
Automate a cell to clear
Hi! I am creating a database for researchers to borrow equipment. We want as much of it to be automated as possible. When an item is marked as 'returned', a green RYG ball shows up in the availability column. I would like other cells to clear automatically in the row when the green ball activates. How can I write a formula…
-
Sorting in a Sheet
When multiple users are in a sheet and 1 user sorts, everyone's sheet sorts. Is there any way to prevent that? Is there a change coming?
-
New Row notifications via Send option
I want to use the "Send" option to send an email to the user each time a new row is entered, automatically. I have used the Notication Alert but it accumulates the rows in the same email.
-
Automatic Reminders
I am trying to find a solution to set automatic reminder to send an alert to the Project Manager an email alert 2 days before install date so they can confirm with customer the site is ready for install in order to avoid wasted trips. Is this possible? And also, is it possible to add this to the formatting function that…
-
Can a Licensed User in the Team Plan view the Admins workspaces and Sheets?
Hi, I've purchased the team plan and apart from me, I've added another project manager from my team as a licensed user so she can create sheets. This puts me at 2 of the 3 licensed users. My question is that can I prevent her from view a specific workspace in the account because even though she is a licensed user on my…
-
Archiving Workspace folders
Is there a way to archive folders in Workspace I no longer need in the Workspace drop down?
-
Comparing Targets and Actual's
I have a data set where the targets are set at the start of the year and as the year progresses actuals are loaded (through Webform) which appear on a different row. I am trying to calculate the performance each month (Actuals / Target) but I dont know how to calculate this when the values are on different rows. I'm sure…
-
Web Form Functionality
Greetings All - I am just shy of completing the academy but I do have a question to complete a project I am working on for a company. I would love to utilize the web form option; is there a way that columns, rows, and fields be manipulated in any other way? Adding fields are fine but that just adds columns and not…
-
Smartsheet is not available
A few minutes ago I tried to start Smartsheet in Chrome, but got the following message: "Smartsheet is loading... It is taking longer than normal to load Smartsheet. In certain cases, a network or internal anomaly will prevent Smartsheet from loading. Press the Refresh button on your browser to re-load Smartsheet. Please…
-
Update Requests
In my smartsheet I have a number of different tasks that have a variety of deadlines and have different people working on each task. Is there a way that I could set smartsheet to send an update request automatically if the task is not shown to be completed by the deadline?
