-
Formula for RYGB Symbols using % Complete AND Due Date
Hello all, I'm trying to create a formula in the "Health" column that will display RYGB symbols to indicate the following: Blue = 100% (Complete) Green = greater than 50% (In Progress) Yellow = less than 25% (At Risk) Red = 0% (Delayed) I am to use the "% Complete" column AND "Actual Due Date" column to determine what the…
-
Locating the parent of a parent
I am trying to take the value from the primary column of a level 0 parent and insert it into another column in a level 2 child. =PARENT([Task Name]@row) works fine when there is only level 0 and level 1. Something like parent of a parent is what I have imagined would work, but =parent(PARENT([Task Name]@row)) is…
-
COUNTIF & COLLECT Functions Not Working
Data Example: Formula Using: =COUNTM(COLLECT({Project ID}, {Project Manager(s)}, $Label@row)) Where row = Project Manager Name As you can see in the actual results, it's not counting the project ID at all when there is project manager.
-
Functions for synchronizing Predecessors and Jira Issue Links
Hi everybody, I am currently trying to set up the smartsheet-Jira-integration. A lot of things really work great but there is one thing.. I want to have Smartsheet as the "leading tool" for handling of predecessors and therefore sync this information to Jira through the issue links field. To give a simple example, I used…
-
A date column doesn't recognize a date structure even though I'm using the DATE formula
Hi all! I've been truggling with this formula since the last couple of days, and I can't seem to find the error. I need the "Finish" column to contain the date from "Column 4". For this, I'm using a helper column ("Finish I"), that extracts the date from Column 4 and converts it to a standard format. Then, with the…
-
How to calculate the sum of all rows of a column starting from 3rd row ?
Column row1 Total row2 =SUM([Column3]:[Column]) this should be sum of all the rows starting from 3rd row row3 1 row4 3 row5 25 row6 21
-
Date-Format Not Mail Merging Properly w/ Google Docs
Hello, I am using SmartMerge, to create a Google Doc from a Smartsheet. It's working beautifully, except for the date format not transferring properly once the document is merged. On my SmartSheet, the date is formatted as follows: March 14, 2023, but when I merge the document, it shows up on Google as: 03/14/23. If I type…
-
Harvey Ball formula for between two dates
I have set up a sheet with a "date min" and a "date max" column. I have made another column that is a Harvey Ball status column. I need a formula to drive the status balls if the date entered in a 3rd date column "date actual" is between the dates of the date min. and date max. columns. Thank you Smartsheet gurus!
-
Merged: Data validation
This discussion has been merged.
-
How to count # of item within a date range
All, Can you help with this? I am trying to count the number of product launches we have planned by the quarter. I have used COUNTIFS to count the total of launches for the year, but need to now add and additional criteria of within a date range. Would that still be the COUNTIFS formula?
