-
Formula to record attendance using check boxes and flag the row if missing meetings?
I am new to SmartSheet and need assistance creating a formula or function to make it easier to to keep up with attendance for meetings once a month. Any one person from the group can attend and as long as one person does, the entire group gets credit. I would like to use a function which will give me a quick indicator that…
-
Sum Children formula
Hi all. I am having an issue with getting a correct sum from children of a parent row when using a formula in the children rows. Ex: Children row formula is =IF([Date Completed]43 > [Due Date]43, "1", "0") There are two children rows; the formula above creates a 1 and a 0 respectively, however, my =SUM(CHILDREN()) formula…
-
Counting open tickets based on company name and ticket status
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 Name]@row, COUNTIF({Maintenance tracking Sheet Range 3}, {Maintenance tracking Sheet Range 3} = "Open")) But I'm getting an…
-
Convert Symbols to Numerical values
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
-
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…
-
COUNTIF in Sheet Summary
I am using this simple formula in a new field in Sheet Summary & I keep getting an "Unparseable" Error. =COUNTIF(RESPONSIBLE ENTITY:RESPONSIBLE ENTITY, "FIRM")
-
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…