-
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?
-
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
-
Cells deleting contents
When i click into a cell the contents deletes. The cells have been prepopulated by an admin user and when i want to view a cell in the line or to mark task as completed the data within the cell is removed. (This is only when i click once)
-
Can I lock columns, and give specific edit access per column?
Hi I currently have a team of 5 people who will be updating a smartsheet every month. Each person has to update their own specific column with data, is there a way to grant access to a person for that specific column so other people can't over write it? I know I can lock rows and columns and grant access, but it seems that…
-
Reminders
Im hoping to create a reminder or email 5 days before a due date? Is this possible??
-
Limit View within a Sheet (using Web Forms)
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of all requests combined. Currently, when I test this I am brought back into the sheet where I can see ALL requests. Does…
-
Max cell limits for all customers
Are the following limits the same for all customers: * Max rows: 5000 * Max columns: 200 * Max cells: 200,000 Thanks, Rod