-
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…
-
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!
-
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?