-
Half Day - Vacation Days?
hi, I am using the smartsheet vaction tracker as well. Has anyone figured out how to track half days? thanks in advance.
-
Is it possible to create a web form with appointment time bookings?
Hello, We're looking to run an event where people can meet 1:1 with an onsite consultant but want people to book a time. Does SmartSheet allow the creation of a web form where people can select from a time slot and then it no longer become available for anyone else? Thanks, Julie
-
Approvals, Updates and Deleting Attachment in a Webform during Update
HI there. I am only a month old Smartsheet user and currently under the Business Plan. i am building the New Hire Request Form for our company and I came across with problem in the multiple approval as well as the things to do before a request will be approved. When the requestor filled up the request form, it will prompt…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
autonumber column exceptions based upon a checkbox
I have an auto number column that I use to assign an employee number to new employees. From time to time we re-hire a termed employee, in which case we do not need a new number - we would just use the old. I have included a checkbox if the employee is a rehire. My questions is - how can I have the auto-number column not…
-
Change Links in @ Mentions and Alerts/Notifications
Hi there, Checking to see if this is a feature before I submit a Product Enhancement Request. When our users get an @ mention in a comment or manipulate certain columns via reports Smartsheet kicks off some automated e-mails based on the users preferences. In those e-mails are links to the sheet where the comment was made…
-
RYG Automation using Drop Down lists
Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If someone chooses 'On Hold' from the drop down, I want the RYG column to show Red. If someone chooses 'Interviews and…
-
Applying Formulas to Entire Columns
Hello there, I'm new to the community. Our company has adopted SS for projects and we're now looking to expand the use to HR, specifically starting with leave requests. I've started a leave request sheet based on the template below, with a few adjustments geared toward my company.…
-
Calculating Remaining Eligible Vacation Days with already Approved / Declined Requests
Hi there, Is it possible to do the following in SS? I'm currently working with two sheets, Leave Requests and Employee Directory. * My Leave Requests is the main sheet I'm working with - a running list of all leave requests from our staff * My Employee Directory is a reference sheet for the number of annual vacation days…
-
Hidden Column Data Viewable in Export
Hello, I have a table where I hid Column C that has confidential information. Viewers and Editors cannot Unhide the columns of Confidential Information. This is amazing. However, here's the kicker... If the viewer/editor Exports the smartsheet they can unhide the hidden columns. How can I stop that to keep these…
