-
Merged: Allow unlimited deletion of columns like Excel
This discussion has been merged.
-
Has Children Function
Hi, I am trying to create a formula that will output the average of the child rows IF and ONLY if a line has child rows. If a line doesn't have child rows, I would like it to output (for example) the number "0" if the status column, Status@row, is "To Do" and "100" if Status@row is "Complete". Please let me know if there…
-
Automatically calculate % Complete based on Dates
Request to improve % Complete column formula. Currently provided % Complete column formula will never be accurate if you also have identified Milestones since Milestones are only identified if Duration = 0, so % Complete will never show 100% for the associated Parent Rows. Currently provided % Complete column/column…
-
Back to Basics: Column Description To Show on Sheet
It would be helpful if a column description could be shown on the sheet as a row rather than indicated with an i. The work around is to use row 1 but this means, an additional column with a flag needs to be used to exclude this from reports. It also means that if have a column with a date, you cannot enforce dates because…
-
How to add only the $ Symbol without the currency in the PDF document?
Hi all, How can I make sure I can show the $ symbol in the PDF file without the currency? My columns shows the value without the currency: But once the PDF is generated it comes with the NZcurrency, which is what I do not want. Thanks in advance.
-
Dropdown of column names for all Smartsheets in the organization
There is a fundamental function missing in the Smartsheet of naming columns same fields as other sheets for consistency prevent automation errors due to sheets primary column conflicts reports end up having several columns with "älmost" same names, when you do filters you will need to add the filter for both names,…
-
Issues with Convert to Column Formula
Hi, I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information. The column's type that I'm trying convert is "Symbols" and is the Progress Bar. The Formula of the attached example is: =IF([RPM %]851…
-
Dynamically choose column to sum/countif from a wider range?
I am working on some budget tracking. I have a source sheet with each expense account and how much is budgeted for each month (Jan-Dec) and it goes back years. I want to display the info on a graph that show Jan-Dec and the sum of all expense account budgeted amounts in each cell. Right now in my metric sheet I have the…
-
Merging Columns together from different sheets.
I have two separate sheets, both tracking job #'s. They are different job numbers and I want to bring those numbers over into another sheet with the column title DRR/Job # (the two different job #'s in one column). Essentially we are tracking the amount of different jobs per persons name so I guess also, how can I…
-
URL String Query for Column Type: Contact List
Hi Smartsheet, I'm trying to help a few new users within my organization by prepopulating a couple fields in commonly used forms with the use of URL String Queries. So far I can seemingly prepopulate almost all fields in a form, but the hurdle I've come across is when the column type is a contact list. The drop down values…