-
Quick Question
I don't understand this thing.
-
Help! I accidently deleted a sheet and need it back!
I accidently deleted a sheet that contains important inormation and I didnt create a backup. Is there anyway to recover my sheet?
-
Merging Cells and Exporting Reports to PDF via the App
Hi there, I love Shartsheet, but one constant aggravation for me is the inability to merge cells. In my quest for a solution, I've come across a few posts on the blog (some as old as 2015) where similar requests were answered with a generic "we'll pass this along to our developers" type response. Just curious: is this…
-
Google Forms sync - access denied
Hi, i have enabled Google forms sync for Smartsheets, when I click the add-on for smart sheets in a form and it tries to connect to SS, I get this error: Smartsheet Sync: Has been denied access to your data. any help on what is going on here?
-
API Access Token for Single Sheet
Hi, I would like to generate an API Access Token for a single sheet. Currently, if I provide my API Access Token in a script for others to use, they can use it to access all of my sheets (and those shared with me). Please let me know how to do this. Thanks, Brent
-
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
-
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?
-
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!