-
Formulas in Jira linked Sheets
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 some information. After the first mapping, I can easily add these columns, but my issue is that every time a new Jira is…
-
Average of project completion for current year
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 year-after-year and am trying to stay away from specifying "2019". The formula I have currently is: =AVG(COLLECT([%]:[%],…
-
Show only own tasks in calendar
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 calendar (via ics and directly). There also all tasks of everybody are shown. Is there a way to show only your own tasks (you are…
-
Publishing only filtered list to google calendar
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 specific tasks assigned to me. I've attached a detailed description of the issue I'm facing with screenshots. Does anyone know…
-
Importing\Uploading Information
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 continue to be used, and import it into SmartSheet, then you want to update the information in the SS later by just…
-
Formula Confusion!
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 older version to muck about with layout at set up at this stage hence the old haulage dates! Each order has details of the sizes…
-
Resource Views by Project
I am having numerous challenges with the Resource Views and not finding them particularly useful. I only want to see resources for particular sheets, my preference would be to select a workspace that contains all the sheets but as this is not available I am selecting all the sheets individually, however, I am still getting…
-
Card View - Card Layout
We use smartsheet as a CRM/Project management. Each Row is a new project we are quoting. In the rows we have over 25 different columns. The way we usually view and enter data in them is in card view. The problem is I would like to change the layout when viewing in card view, not just the order they are in, but actually…
-
Actual % Complete Formula?
I'm trying to answer some questions on why the Project % Complete values are what they are, in greater detail than what is provided in this help article (which just indicates that it is calculated by Smartsheet based on Duration and % complete of child rows). Does anyone know what the actual formula/process is that…
-
help with average formula
Hi, I am having trouble with getting an average of a column. its a formula based column and since some rows dont meet all the criteria, some rows state INDEX DATA. How do I find the average of the numbers in the column using a formula?