- 符号转换为数值
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
- 上校or Coding for Names / Owners only
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 in purple, and Laura in yellow, so that they can quickly see tasks they are assigned to. Right now, I can only set a…
- RYB Automation Question
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, Green, or Yellow status ball with the conditions below. IF the SmartXpo Launch Date is between 100-90 days, then assign a…
- Help with an existing RYGB Formula
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 formula to ALSO take into consideration that even if the status is "in progress", however, the % complete is less than the…
- count tasks per week number
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 every time (at least not an error) : =COUNTIF({6530 - Sulfuric project Schedule Range 5}, WEEKNUMBER({6530 - Sulfuric project…
- Visual Status bar with dates
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 Fulfillment Status is "empty." If the Date 1 column has a date, then the Fulfillment Status is now a "Quarter" full and so on…
- Upcoming free webinar on 3/19: Advanced Formulas!
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 webinar, you will learn how to use formulas to: Automate column data, including flags, symbols, and drop-down columns Look up…
- How can I compare two dates and then add thirty days to whichever date is later?
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. example comparing "Release Date 1" to "Release Date 2" give me whichever date is later plus thirty days. Thank you so much for…
- Creating an Age Pending report
I am fairly new to Smartsheet and trying to create an age pending report. I have used the =IF(Submitted By = 1, 0, (Created1 - TODAY())), and receiving an error message. Could someone assist me with this please?
- I am trying to setup a notification for when an ID is used twice within a column.
I am trying to setup a notification for when an ID is used twice within a column. I have more than 100 ID within the sheet and the sheet is still being populated so using the condition if equal to isn't quite efficient because it will mean I have to go into the automation to check the ID each time a new one is added. Is…
