-
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?
-
At-risk Formula Help
I know this has been posed 7 million times already, but I need help with an at-risk formula... I would like a flag in the "At Risk" column to automatically populate if the following criteria is met for that given row: IF a row's "End Date" is within 15 days from today’s date AND "% Complete" for that row is less than 50%…
-
Enhance the VLOOKUP function to take a date, using it to lookup the value in the cell history
Sorry if this is a duplicate. I can see the Idea that I created earlier today in my notifications. It states that the status has changed. But when I click on it (https://community.smartsheet.com/discussion/102567), it says the discussion can not be found. So, here I go again.... We have % Complete and Ranking (Top 20, from…
