-
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…
-
If Formula for Complete, In Progress, At Risk, NA
Hi, I need help with a formula so that the Child can filter to complete, in progress or at risk based on the status for the items of the descendants. Additionally, when NA is set as a status for a line item I don't want NA to be set as the status for the child, since that is not an accurate representation. I think I have…
-
Countif / Countifs values are between "0" and "10"
Hi all, Struggling with a formula and could use a hand. I'm trying to display data which shows me how many values are outstanding between 0 and 10 days. I've tried a few formulas but none of them seem to be working, which is driving me insane! =COUNTIF({MS - Range 5} < 10) As shown in the above, i've even tried to simplify…
-
Index/Match with a Date -- Date isn't a true date
I'm brining in a date with an index match formula. The date is coming in and displaying as a date, but I'm not able to utilize this field as a date. For example, if I want to filter that column to "in the past" - it's not picking up on it because it's just coming into the cell like it's text. column is a date column.