-
Change date every week
I have a sheet and I want resources to provide their status update every week. A request to update is sent every Friday. I want the "Current Week Ending" to be the Friday of the current week. Resources can enter their update for that week starting the Wednesday before till the Tuesday after. Every Wednesday, I want the…
-
COUNTIF/S Formula?
Hi All! Needing some help with the below query, the outcome is extremely straightforward but I feel my immaturity with SmartSheet is causing some blockers. Question at hand: I currently require the formula COUNTIF/S to count multiple criteria within a row but I can only seem to get it to work for one. For example I need to…
-
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…
-
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…