I'm using the JIRA connector for Smartsheet. I'm attempting to use our "original time estimate" field from JIRA for the "duration" column in Smartsheet. It looks like JIRA sends the time estimate info…
Hello, I am looking for a little direction. I am new to smart sheet and went through basic capability trainings etc. However, I am looking for assistance in having a smartsheet automatically move info…
It won't let me hyperlink a copy of it but here is the URL for those who trust I'm not trying to do anything scary. https://drive.google.com/file/d/0B8APP67r815BaVdmRkxrRlVKRDA/view?usp=sharing So thi…
Hello, I'm trying to create a %Complete column based on a drop down list column called "Status". For example, I'm looking to combine these formulas into one cell, then copy and paste to all other cell…
I am wondering if someone has some advice on the best infrastructure columns to add to project sheets to enable formatting, portfolio rollups, metrics, etc. I current have automated checkbox hidden co…
It seems like others have inquired about VLOOKUP. I'm sure this is in the works as part of "enhancement request". Is there a timeline when this will be released?
Looking for some help in a Form that I'm creating. I am the Safety Director for a painting contractor and I'm trying to create a form that my crew forman will be filling out every morning. Why can't I…
Hello Fellow Smartsheet Community Members, I am wondering if anyone knows if it possible to sort items in a workspace by the item type. I have a workspace that has a mixture of sheets and reports. Ide…
I was working in one sheet (with autosave on), switched to another sheet and when I returned the rows were missing - there is no hierarchy/drop downs and it looks like the rows are ´hidden´. Any ideas…
Hi Again, After scouring discussion boards I have managed to Average the total of the rows, see below =IF((COUNT([Days to respond]194:[Days to respond]214)) = (COUNTIF([Days to respond]194:[Days to re…