-
Need to build formula that includes a drop down menu as an option, need advice
I am trying to build a formula that includes a drop down menu as an option. This is what I am trying to do ... =IF([COLUMN1] = "Campus name", then [BUILDING NAME], otherwise "Please select your campus before selecting the building name") * COLUMN1 would be a drop down menu with campus names * BUILDING NAME would be a drop…
-
How to link appended cells /row in source sheet to destination sheet
Hi, I have ben able to learn how to link cells from source sheets to destination sheets and observed auto refresh in destination sheetfor teh cells linked already. My query is, if additional cells/rows are appended in source sheets ( quite possible), what is the way to get these also automatically refreshed/refklected in…
-
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
-
Automated Reports
Is it possible to create automatic reporting and dictate who would receive them? I'm hoping to have all outstanding issues pulled from my Smartsheet each week and distributed to the team to make sure nothing slips through the cracks. Thanks!
-
Web Form Submission Notification
When a web form is submitted, and a record is generatied in my SmartSheet, can I get a notification email containing the Web Form information that was submitted? We have people registering for a conference, and need to know when a new registration is created.
-
Outlook 365 Calendar
Is there a way to link reminders to our Outlook 365 calendar? We already log in through 365 and it would be great if we could!
-
Tracking Hours in a Day
Hello Fellow Smartsheet Users, I am looking to track hours in a day to maximize bandwidth per employee (OCR Racing & Building Obstacles). Unfortunately, Smartsheet doesn't have the ability to track hours in a day and to accurately display this in a Gantt Chart so I am looking for recommendations/tips, best practices, etc.…
-
Email Link
Is there a way to click on an email address in a smartsheet and have it open up in your email program that you are working with? Ex (microsoft outlook)
-
What is the best way to associate prospect contact information and sales tasks to a smartsheet sale
We currently use smartsheet for our sales pipeline. I love it. As our prospects move through our sales cycle, we simply move them down the list. I use the formulas to track all of our conversion rates and apply to project types and marketuing sources. I find this reporting and linking feature invaluable. We use the…
-
Error in Loading the Form
When people try to follow the form link, they are getting "Required Field" error page instead of loading the form. below is a screen shot. When I got notified by email from some applicants [and this is embarrassing], I followed the hyperlink to land on the same error page. Is there a solution? or this is the service level…