-
Setting conditions for RYG balls
I would like to have the RYG balls automatically adjust based on another status column. For instance, if my outside sales people set the status of a row from bidding to the following: Status "Lost" = RED Status "Postponed" or "Unknown" = YELLOW Status "Won" or "Obtained" or "Negotiating" = GREEN Status "Bidding" =Will…
-
Improvements to Help, Activity Log, Branding, and Navigation
We’re releasing a new update this evening (June 20th), here’s what to look out for: In-line Formula Help—Quickly see syntax for formulas as you type them in a cell. We’ve also revamped our Functions content in the Help Center, which you can find at https://help.smartsheet.com/functions Activity Log—View the Activity Log of…
-
SUM Function is not working properly
Hey Everyone, I'm currently working in an area where my SUM formula is simply not working, my formula is =SUM(ColumnB127:ColumnB133) and it continues to return a value of 25. Below I have provided a picture. I even thought it may have something to do with the value's being linked, and pulled those values into a separate…
-
LastChild() function?
Is there a way to display the value of a cell from the last row of children in a given parent row cell?
-
Sum formula Error When References Results from IF Formula
I am getting an #Invalid Operation error when my Sum formula references a cell with results from an IF formula: =SUM([Column 8]1 * [Column 9]1) results as #Invalid Operation error Column 9 formula =IF([Column 2] = "A", "0.5%", IF([Column 2] = "B", "1.5%")) I've tried to fix by using a nested VALUE= but that does not work…
-
Formula Help
This might be simple, but I can't figure out a good formula for dates. What I have is a column with dates, and another column (Year) next to it that is hopefully an If statement. Something like IF the date is in 2015 THEN put a 15. I need this column so I can reference this Year column when calculating total investments…
-
RYG Roll-up
Hello, I am trying to create a formula that shows a green ball only if all children have a green ball. Thanks.
-
Formula to count a number of dates, based on a date range.
Im trying to create a formula for a report based on howmany entrys have been created within specific date ranges. For example: how many entrys have been created 04/15/15 - 04/20/15 in column "date of entry" (auto number column). Please help! Best regards,
-
Autofill a value
Hi. I'm new at building formulas in Smartsheet. I have a numeric column that I want to autofill a 1 if no value is entered. Can someone help me with this?
-
Multi-Sheet & Few Clicks
I have an assessment sheet where 2 different rating columns are linked to the rating key at the top of the column. Would it be possible have the Rating Key Sheets linked or formulated so that when a rating is selected on the key, it'll enter it into the cell on the Assessment sheet? Does anyone have any suggestions / best…
