-
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…
-
Starting a task based off of a column selection
Sorry if this is covered elsewhere and if it is can someone send me a link? Basically we are setting a sheet and are hoping to auto add a child row based off a column selection. Ideally we could choose what if any to prefill in it but even just being able to get a child row to auto add would be a huge help.
-
Approval process automation
I'd like to create a workflow which will collect data from a webform (can I edit the look & feel of the web form UI?) and have that data forwarded to several people for approval without the need to go to echosign. The webform is the easy part (thank you Smartsheet), but the rest of the approval confirmation on the sheet…
-
Modeling uncertainty: "Expected Value" for staff allocations on future potential projects?
My company is a consulting firm that must manage an uncertain project flow. We use one Smartsheet per project, creating a new project smartsheet whenever we submit a project proposal. However, there is always uncertainty as to whether we will actually get any particular project. We definitely don't have a 100% success…
-
Hover over column to reveal full title
this would be helpful since I have some columns with long titles but the values are small numbers so the width of the column truncates the text... it'd be nice to be able to hover my cursor over the column header to see what it is.
-
Determine Hours from Duration
Has anyone created a sheet or formulas to calculate the montly hours from duration? This is easy if the entire duration falls in one month but I'm struggling with calculating the monthly hours for extended durations. For example, how many hours are allocated in each month if I have a task that starts January 11, 2016 ends…
-
Complete a Partial Update Request
Our marketing department sends update requests to our project managers so that we know which projects are expected to be marketable projects. If they are marketable then it triggers other actions. Often, I have 10+ projects that I need a single project manager to update me on. Is there a way to send an update request that…
-
Formulas and Sheet Saving
All of the sheets in my solution have a date column for "Today". =TODAY() I use formulas in several other columns to determine if the checkbox column for Current Qtr should be checked. (same for Previous Qtr and Next Qtr) I use the checkboxes in report filters. Problem: Because my formulas are updating sheets daily, I have…
-
Non-working days for the enterprise
Would like the ability to set non-working days for an enterprise, with the ability for individual smartsheets to opt-out.
-
Designating Focal Date in Calendar View
Does anyone know if it's possible to have the calendar automtically use a date prior to today's date as the focus when displaying the 1 month, 3 week, 2 week, etc., display? By default, it displays the current week at the top of the calendar whenever the calendar is opened. Also, whenever I refresh the browser, the…