-
Synching multiple items per day to Google Calendar
Hello, My company tracks vacation/personal days using Smartsheet. We export to Google Calendars which is what we use for most event/meeting planning. The problem I'm having is that when more than three people take the same day off, only three of the people show up on the Google Calendar. Its only happened a few times but…
-
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…
-
Sharing Resource Views with Other Resource Viewers
We are getting started using SmartSheets Resource Management tool and I would like to create a few different resource views for some of our supervisors. Essentially each supervisor will have a view of their team so they can see what projects their team is working on and when. My issue is that I've created a few of these…
-
Ressource Management
Within a team of 13 users in Smartsheet, we are struggling with the resource management and allocation of tasks. If I want to allocate a task to a staff member which will require 30% of his or her time over a period of 2 months (but without knowing when he or she will work on this precisely), how can I do that ? Also, if I…
-
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…
-
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.
-
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…
-
Worksheet for Employee Referral Program
Hi Community, Would like some buy-in from the community to see if anyone has created really great employee referral program sheets that have helped their business? I'm sampling some of the templates arlready in SS, but thought I would see if anyone one else had some awesome sheets they'd be willing to share. Thanks, Kris
-
Recruiting Metrics
Hi SmartSheet Fans, Wanted to start a discussion with the community revolving metrics and how you've used SmartSheet to get you recruiting metrics (time to fill, 1st touch date, etc.). Since everything is date related we created formulas to help us, but would love a different approach if anyone has any. Thanks! Kris
-
Will adding Data unto Webforms be added automatically to the spreadsheet?
How do I get the data I entered on a webform to get added unto the spreadsheet I am working from? Can I do both or does it have to be either 1. use the Webform or 2. enter data unto the spreadsheet?
