-
Creating Reminders from Mobile App?
Is there a way for users/collaborators to set reminders to themselves or others through the use of the mobile app? I'm trying to develop smartsheets to be used by field sales representatives, and the goal would be for them to use the program 100% from their phone or tablet. I do notice the ability to set reminders, as a…
-
Critical Path
Does Smartsheet have the ability to calculate and show a gantt's critical path, like Microsoft Project's Critical Path Analysis (CPA)?
-
Populating existing sheet rows through a form
I'm looking to collect weekly sales reports from a number of sales teams spread across different countries. Ideally I want the data from each weeks sales report to drop into a row (with the week number and/or week end date) in my master sheet. Some of the data in the master sheet will be pre-populated (overal…
-
Why can a colaberator add a row and not a column
I have colaberator that say they can add a row but can not add a column to a sheet... Can this be done or is this a restriction?
-
Editing Radio Buttons
Does anyone know of a way to edit a radio button list after the inital list is created and added to a web form? We have a product list that we'd like to edit periodically without having to create an entire list each time. Thanks
-
Order value based on price breaks
Hi, I have ~30 products each with four price breaks and I need to determine the value for each order (a single product type is listed per row) based on the ordered quantity and its associated price break. The really clunky method I have used so far is two main nested IF formulas and additional columns:- The first main…
-
Collaborator access by row
We are using Smartsheet as an opportunity tracking tool. I would like to give partners outside of our company access to only certain rows in the sheet. The update request functions works really well, but that's only for one update at a time. Is it possible to keep that link open indefinitely?
-
Day of the week formulas
How do I schedule repeating appointments on a specific day of the week; Ex: Every Mon at 10:00 First Tue of the Month at 09:00 I did not see the day of the week variable or formula. Thanks Alan Guggenheim
-
Formula To Ignore Zeros In Averages?
I have columns running left to right with the 12 months listed as the main header of each. I want to have a column on the far right that shows our average month's sales based on each months totals we go. RIght now it is May, but the simple AVG formula also counts June-December sicne they have zeros in them. So, instead of…
-
Misaligned column headers
How do i realign columns and columnn headers in a large sheet? They appear progressively more staggered across the page. Here is a shot of the page about half way across, Very confusing! Thanks, Ray.
