functionality
Discussion List
- i have a repotr based on sheet with ~1500 rows (parents and children). as i know there is no way to show the parent and children in repost so that i mark in color the parent and sort the report to sho…
- Hi, I'm trying to count the number of open tickets by company name, and the cells I'm referencing are in another sheet. Here's my formula so far: =IF({Maintenance tracking Sheet Range 2} = [Company Na…
- What is the formula to convert the bar symbols of Empty, Quarter, Half, Three Quarter, Full to numbers? For example, Empty = 0 Quarter = 1 Half = 2 Three Quarter = 3 Full = 4
- I'm trying to find out if I can color code only the name bubble. For example, below I'm using the multiple-drop down column formatting and all names are shown in grey. It would be nice to show Whitney…
- Hi, I am looking for some assistance with automating the RYG Status Balls in my Sheet. Below is my data, and I am attempting to key off the "smartxpo launch date". What I want to do is assign a Red, G…
- Below is the current formula in a RYGB column. In the current set up, if the status is "not started" but the End date hasn't past, it will be yellow. Which is fine, however, I would like to update the…
- Hi community, I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year. Here is my formula that calculate 0 ev…
- Hello - First time posting here! 😁 My question is I am trying to create a formula that will populate the visual status bar and show progress as dates are entered. So if no dates are entered, the Fulf…
- This webinar is the second in a two-part series focused on formulas. Use advanced formulas to automate information in your sheet and gather insights into the work you manage in Smartsheet. In this web…
- Hello and first off thank you for your help. I am trying to build a formula in a third column that will allow me to compare two date columns and then add thirty days to which ever date is later. examp…
