Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Formula to collapse rows
I am looking for a formula to collapse the sub-task rows into the parent after all sub-tasks are completed. I found a formula that will check mark the parent row after all sub-tasks are checked complete, but want to collapse when that occurs. I would like to add that onto this formula: =IF(COUNT(CHILDREN()) =…
Conditional Formatting - Filter odd/even numbers
Is there a way to filter and do conditional formatting for odd/even numbers used from auto-number? If not, I would like to pose this as an enhancement request.
Smartsheet for Outlook: What if we want to add a row in a specific spot?
I have a sales pipeline sheet that is organized by month, so new rows going automatically to the bottom of the sheet (under december) would not be ideal. Say I had an opportunity for June, how would I insert a new row in there from my Outlook?
Error - Web form - "The item is not currently available..."
I am getting the following message when I am uploading a webform (Image attached) . Can anyone point me in the righ direction here? what I am doing wrong?
What is wrong with this formula in totaling in parent row?
I have a parent row I just can not get to toal the "Win Ratio" (it is a percent) if there is a ZERO in one of the child rows! It is driving me crazy! The colums are: Phone Calls | Accts Created | Win Ratio The Daily formula works even when there is a ZERO in it... I am using this: =IF(AND(ISNUMBER([Phone Calls]18),…
Should I have a PM Lite Smartsheet? A One Pager?
This time last week, my CIO asked me to look into Smartsheet. One week later I have a beta version of a project template containing 6 sheets, 3 reports, and one dashboard. I was surprised how easy it was to develop a pretty solid solution in such short amount of time. The beta version of my project template should work for…
Conditional Formatting - Track Cost Fluctuation
I have a master list to track the cost of an item. Is there a way to format cells to change the font to Red or Green based on whether or not the value is higher than a previous cost? IE: In 2015 cost was $1 and in 2016 the cost rose to $2. I would want the 2016 cost to automatically turn Green to show that there was an…
Date Formula in a Gantt Chart Cell
I have tried to add formulas in the start date column for a gantt chart that reference a base start date cell and add a certain number of days to the start date. Is that possible? Example of the formula I am implimenting: = StarteDate + 10 The gantt chart start and end date columns use the Date/Time type of cell and Date…
Help! sum children if word1 and if word 2 are in row
I am trying to sum children in a column if two specific words are present in a row(s). IF "word1" ANDIF "word2" are present = sum of children
Combine 2 or 3 cells into one?
I have a webform that collects data for a request, Department, Type, Etc. These are separate columns. I would like to somehow filter the some of the information received into one column, which would then be a code for that particular request. The code is then used in other locations as an identifier. Is there any way to do…
