-
Omit records with No data on Charts
I have a Workspace with a form that feeds into a sheet Then I have a calculations sheet that adds up everything (most of which us SUMIF). Now a few of these Workstreams (which are in a dropdown list on my form/main sheet do NOT have any data currently associated with them. But that will change. And like I said these…
-
How would I use an Index/Collect formula to include Child Row data as one of my criterion?
For example, I would like to collect a certain column based on a specific text string in another column, however that text string is located in a child cell/row which I believe is the reason I am receiving an "Invalid Value" error. I have two separate criterion in my formula, and I removed this text string portion to…
-
Is there a way to get todays date?
Hello I don't think this is possible but i was just wondering if there is a formula or way that i could use to pull today's date and have it auto populate the cell once the form is submitted. Currently I have it set up so in the form they fill out they just enter today date but i didn't know if there would be a way to…
-
At Risk triggered by formula
Hello!! I'm trying to target the "At Risk" column with a formula to "flag" automatically. I need to have my At Risk flag marked automatically if a task is overdue [End Date] and the [Status] is "Not Started" and "In Progress" I tried using this formula: =IF(AND([End Date]@row <= TODAY(), Status@row <> "Not Started" "In…
-
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
