-
Smartsheet/JIRA Connector: Errors during Sync (Proxy Errors)
Hi there: So we have a number of smartsheets linked to JIRA via the connector and over the past couple of days I've been receiving error emails that say "Invalid response from JIRA. statusCode: 502, reasonPhrase: Proxy Error statusCode: 502, reasonPhrase: Proxy Error" Assuming we need to contact JIRA/Atlassian about this…
-
Stop Smartsheets.com from sorting spreadsheet alphabetically by the first column
How can I stop Smartsheets.com from sorting my online spreadsheet alphabetically by the first column? I have pasted this spreadsheet directly from Excel 2016 and I want it to stay sorted in the original order; I don't want the spreadsheet to be sorted by alphabetically by the first column within Smartsheets.com. How can I…
-
Multiple Project Task List Roll Up
Hello, Is there anyway to have a project task list that is updated from multiple project task list sheet? We are looking to have a master roll up of the Project Milestones without including all the tasks on 1 task list. Thank you
-
Link limits regarding Vlookup
My question is regarding this statement: "There's a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total." If a cell on the inbound sheet is reading a range from another sheet, do all the cells in that range count against the inbound sheet, or is it just the one cell that is…
-
Inserting a Formula into an existing Equation
I have a simple math equation in one of my cells, and in place of one of the numbers I would like to reference a count of cells with dates in them in a certain column. My equation is: =100 - (((60 / 477) * 100)) (this returns a number in a percentage format) and I would like to replace the number "60" with…
-
Referencing % in Formula in Symbol Column (RYG)
Is there a trick to referencing % Percentages)when using the If function, automating the RYG symbols in a Symbol column? I have a simple IF formula referencing cell formatted to %. When I replace the % with any text and update formula to reflect the change, the correct RYG symbol is displayed. When I attempt to reference…
-
Conditional formatting for all children?
Hi, we principally use smartsheets to generate Gantt charts for our various projects. Ideally we would like to set up conditional formatting (for example task-bar color) for all of the children of different parents. So for example, let's say "Phase 1" of a project is the parent, we would like an easy way to have the…
-
COUNTIFS returning #INCORRECT ARGUMENT SET
Hi all - I cannot figure out what's going wrong here. I'm trying to count rows in another sheet ("Sheet A") where both the following are true: * Done = 0 * IsChild = 0 My formula is: * =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 4}, 0) Now this works perfectly! So in a cell right below that one, I then try to count rows…
-
Help converting and excel formula to smartsheet
Hi everyone, I'm pretty new to smartsheet so I may be asking your help for something that is quite easy to do :) I have an excel formula that I need to migrate to smartsheet to help me transform seconds in HH:MM:SS The excel formula is =TEXT(IF(I4="";50;I4)/(24*60*60);"hh:mm:ss") & ":00" Is there a way to use the same…
-
Allocation in Template Sets
Good morning. I joined the webinar yesterday regarding Template Sets and we've already begun creating a sheet for our projects using one of these template sets. Great job Smartsheet!!! We love the compatibility you have created with Project and this will definitely benefit us in the very near future. I did notice, however,…