-
Update Smartsheet
Hi everyone, My company just finished our event in 2017, and I want to take the same exact smartsheet from last year and use it for 2018. Is there a way to take all my past bullets, and change the dates to 2018 without changing them all manually? Thanks for any help with this!
-
Capturing data from a Magnetic Strip
I was wondering if there is any way for Smartsheet to capture or populate information if we swipe a card that has a magnetic strip? I.E. can we have employees swipe their ID badges and capture their employee ID number?
-
#UNPARSEABLE error
Hi everyone. New to smartsheets and im having issues with my formula. Works fine on google sheets but dont know how to get it working on smartsheet. Please see an example:…
-
IF statement with AND/OR
I am trying to create a formula that calculates Days Overdue based on varying approval levels. I need it to calculate if Direct Manager Approval is "Submitted" and Hiring Manager/Director Approval is blank OR if Direct Manager Approval is "Approved" and Hiring Manager/Director Approval is "Submitted". Here is what I came…
-
Selective Count
I’m trying to get a count based on 3 different conditions. The formula that I have so is =countifs($[it track]$2:$status$500, “01. Reporting”, $[it track]$2:$status$500, “ Tier 1”, $[it track]$2:$status$500, “Green”) If all 3 conditions are met than a count is added. But its not working what am i missing? Thanks
-
Human Resources Time Off Requests with Functionality
Hi, I found 2 templates on smartsheets for time off, but neither work, and I have attempted to customize to my needs and I am not able to figure it out. First I want a form that employees can submit their leave, Second create a workflow for approval, and Third be able to tally the balances automatically to the appropriate…
-
Calendar view
I am trying to view a sheet in calendar view that covers the whole year at a glance...I'm pretty sure it's not possible but I'm hoping I'm wrong. Can anyone help?
-
I have a slow sheet
I have a smart sheet that has about 2400 rows with multiple sections this has been going since 2014 however it is running very slow. How can I fix this or can it be fixed?
-
data source for metric widget
When you edit a metric widget, is there a way to display or determine the sheet and cell a metric widget is displaying?
-
Separating Form Submissions into new sheet
Hi everyone! I made the mistake of creating two forms in one sheet. They two distinct links and are for different events. The issue is that I cant separate the responses based on the sheets. Is there anyway to fix this? I need an accurate tally for an event. Thanks!