Does SmartSheet have any way to organize filters? I have a large sheet where everything falls into one of five categories. There are then ten sub-categories for each main category. I would like to cre…
I am trying to get a count of completed tasks by a team by month across multiple sheets. I've created this formula in the sheet summary: =COUNTIFS(Status:Status, "Complete", [Team Assignment]:[Team As…
I've looked and am unsure if smartsheet is even capable of this, but can I turn on a flag based on if a new rows start date falls in between the start date and completion date of any other row? I'm al…
Hi ! I'm trying to do the following: - I've created a Smartsheet that is linked to Jira. - to help me report on that, I want to add columns that are NOT mapped to Jira and to some calculation or add s…
I'm trying to average the "%" column based on rows that are only in quarter 1 (Quarter Identifier = 1), and have a completion date that is the current year. I'm trying to make this sheet roll over yea…
Hi, I am new to Smartsheet. I already searched for this topic, but wasn't successful. By standard, the calendar in Smartsheet shows all tasks of everybody. I imported the calender into my Google calen…
I'm having an issues with "Publish to Googgle Calendar". Every time I've publish some task in google from SamrtSheet, SmartSheet publishes everything in my Google calendar instead of publishing the sp…
I know you can create a sheet by importing a document into SmartSheet and having it auto-create around the information; however, how do you continue this? IE You take a sheet from Excel, that will con…
We are trialling smartsheet and overall enjoying it so far however we have run into a bit of brick wall and any help would be appreciated! We have a main sheet with all our orders on it, using an olde…
