-
Jira Connector Sync - Rows getting rearranged
Everytime I update my plan on smartsheet that uses Jira connector, post the sync with Jira, it re-arranges the rows in a random order (maybe based on order of sync). Why does this happen and how can I lock the rows so that the hierarchy I define on Smartsheet manually never gets re-arranged but only receives updated value…
-
Critical Path not displaying
Hello I have read various other posts about CP not showing. My last task did have a red border but I have since altered this. There is not CP showing. Any advise will be welcome. Thanks in advance Matt
-
Sumif Problem
I get a 'incorrect augment set' error with formula =SUMIF([Int/Ext]10:[BASE VALUE $]100, "Int", [BASE VALUE $]10:[BASE VALUE $]100) and have checked that the column 'Base Value $' is a text/Number format (having looked at previous comments). Any ideas what else to check
-
Column heading on Smart sheet Card
Hi guys Short and sweet. I've been using Smartsheet to provide a rating for the team (example below and attached) Basically, what I would like is to show the actual column header name in front of the Stars symbols. At the moment we know what they are based on knowing the sheet but to a new user they need to keep going to…
-
Can't Remove Dates
I have an old project that may or may not resume. Either way, I want to kind of archive it by removing any dates and moving it out of the way to the bottom of my sheet of projects. I have a few Master Tasks with subtasks. I deleted all the dates on the subs but there are still dates on the masters. I have filters that…
-
Form function for SmartSheet
Hi, I have smartsheet to record each building general meeting info, such as building manager, meeting date, building name. In each meeting, we need to prepare meeting supplies (there are around 30 items, such as pen, projector, binder..). I would like to use smartsheet "Form function". Then link is created and I can send…
-
Formula placement where data rows are constantly changing
Hi All, I am trying to build a report or sight that captures the count of various columns based on other columns. {PLEASE add the funciontality of formulas referencing other sheets}. The count and countifs formulas work well in isolation. I can add the formula in a new column and then hide this column. The problem I have…
-
Scoring
Hello, I am trying to setup a Risk registry where user selects the probability (very high, high, low) and formula in a new column says if High, then score is 0.07. I then want to do the same thing with Impact (user selects impact high, low etc. A new column puts a score based on formula: if high, then 0.05). I then need…
-
IF formula with dates
Hi Can anyone assist with why this formula doesn't work? Ideally I would like to return a text result of "FY18" if the dates are in the range 01/07/17 to 30/6/18. Thanks in advance. Richaerd
-
New Notifications to non Smartsheet users
HI Guys, i have just tested this amazing new future of allowing a non smart sheet user to get notifications i was trying to set it up for clients To receive a notification when i updated a new payment into their Receive payment sheet It works amazingly just 1 problem the attachment of the row which in my case is the…