-
How can I put a drop down menu that dynamically updates or adds another field?
How can I put a drop down menu that dynamically updates or adds another field? I am a Project Manager. In my Web Form I created a Project Name field that has a drop down list of current projects to choose from. After I select a project, I want another field to appear underneath it to give the end user another option to…
-
SUMIFS Function with Multiple Column Sum Range
I want to sum values over a two column range using multiple criteria but when I include more than one column in the sum range I get a #MISSING OR INVALID PARAMETERS error message. When I back off the sum range to a single column it works fine. Is the sum range in the SUMIFS function restricted to a single column?
-
Future Developments
I am a new user to Smartsheet. Still testing it out for the 30-Day Trial. I really like Smartsheet, but am a bit concerned about becoming too involved with it because it does lack some functionality I was hoping for. That said, only a few of the upper end (expensive) project management programs seem to do what I want.…
-
Enhancement Request: Choosing which task to display on Agenda
Hi, A great way to improve your existing features regarding Sync with Google Agenda (or even the regular Agenda view) would be to allow the user to check or uncheck the tasks he wants to be synced, and the ones he doesn't. I use a lot of titles or categories for my tasks and subtasks but most of the time they are…
-
Update Request single use link
Does anyone know if there is a way to allow a recipient of a "Send update request" to use the same link more htan once to update a particular row? An installation within my organization is a single day event but can span the entire day. I may need multiple check-ins from my field tech. Today, I send an update request to my…
-
CALENDAR WITH FORM
I work with the control of scheduling of some cars. The employes need to make a scheduling reserving these cars to use. I would like to know if is possible i create a form where they make a reservation of the car seeing which day is available or not to do the reservation, to do not overlap other reservation made before…
-
shift project dates globally
I've created a schedule but now need to move the dates back globally by about 2 months. In another scheduler I use you can simply globally adjust dates + or - as you need - very convenient when the start date isn't nailed down yet. I don't have all the fancy dependencies set up - I haven't grown that far with setting it…
-
How to use a range of numbers in a formula
Hi SmartUsers, I have a formula to show bars according to the completion % of a cell. The formula is: =IF(Completed?9 = 1, "Full", IF([% Complete]9 = 0.25, "Quarter", IF([% Complete]9 = 0.5, "Half", IF([% Complete]9 = 0.75, "Three Quarter", IF([% Complete]9 = 1, "Full", "Empty"))))) It'll show 1 bar if a task is 25%, 2…
-
smartsheet realtime co-authoring
Can we work at the same time on different records.
-
Formula to calculate count of checkboxes in multiple columns and child rows
Hi Everyone, I'm trying to write a formula that adds up the number of unchecked child rows in the Complete column and then subtracts the number of checked rows from the Non Applicable column. The result should be a number of tasks left to be completed from within that parent and child section. I've tried a bunch of…
