-
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.
-
SUM of Hours column
Hello, I have four columns: Task | Hours | Assigned to | Total hours The 'hours' column is how much time (hours) it will take to do the task, the 'assigned to' you can assign the task for more than one person. Now I need the 'total hours' column to show me how much time it will take for a task (example: Task1 takes 1 hour…
