-
Formula for RYG Symbols in Child Rows to Update Parent Row
Hello, I'm wondering if there's a formula that could automatically update the parent row in a column that has RYG symbols? The parameters would be: -Green overall (in the parent row) if all children rows have green symbols? -Yellow overall (in the parent row) if any children rows have at least 1 yellow symbol? -Red overall…
-
Help with CountIf Formula
I need a count of # of rows based on data in 2 different columns. All data is on the same reference sheet. Here is the formula I have written that keeps coming back as unparseable: =COUNTIF({Global Talent Mobility Intake Range 1}, OR(@cell = "New", @cell = "On Deck", @cell = "Backlog"),AND ({Global Talent Mobility Intake…
-
How to Remove Duplicate Site Names??
Hey Smartsheet Community, I am trying to remove duplicated Site Names from my sheet and am running into some issues. Can someone please help me come up with a formula to accurately remove all duplicated site names? (Backstory: I copied a lot of data over and some of it is duplicated so we are trying to remove the…
-
Complex Formula Help Needed
On a Gantt chart, I've added a column % Progress Expected and I have it calculating % progress expected per day for each line item, based on the duration; see formula below. =(TODAY() - Start@row) * ([ADMIN: % EXPECTED DAILY PROGRESS]@row) * 1.1 The problem I'm trying to solve for is I need it to show 0% progress expected…
-
Week Number Troubles
Good Morning/Afternoon All, I have a client that we are counting the number of requests in a ticketing solution. Currently we are using this formula to count all the requests he gathers each week. =COUNTIFS([Request ID]:[Request ID], NOT(ISBLANK(@cell)), [Created Date]:[Created Date], WEEKNUMBER(@cell) = 7) Once we gather…
-
Add to a date if another column meets criteria
I'm not the best at the complicated formulas and need some help. I have 3 columns in play here. Submission Type (single select), Submitted date (automation added), and Due date (Date Field). If the requestor selects "Standard" in the Submission Type field, then I want the due date to be 30 days after the submission date.…
-
Formula help
I need assistance with a formula. Trying to create if/and statement for a checkbox. =IF(AND([Trigger for Parent]@row = TODAY(), [Submission Status]@row = ISBLANK, 1, 0)) If the Trigger for Parent column = today AND the Submission Status column ISBLANK Check the box
-
COUNTIF Between Date Range
Hello, I am trying to see how many projects were completed in in 2021. I have several different dates and years within the column, but I'm looking for a count of all projects with a 2021 date. The below formula is what I'm using but I am getting #UNPARSEABLE. =COUNTIFS([NOC Recorded Date]:[NOC Recorded Date], >=DATE(2021,…
-
Timeline Variance indicators
Hi, I am new to using Smartsheet and was wanted to confirm a few things timelines related: Can Smartsheet create predecessor and successor dependencies (FF, FS, SS, SF) similar to MS Project? Does Smartsheet allow for WBS elements to be created through indent / outdent similar to MS Project? Can Smartsheet allow linking to…
-
Running Balances for employees
Hello all, I am trying to make a spreadsheet that tracks employee fitness reimbursement balances based off of their entries into a form. Each employee has exactly $300 that they can use per year for fitness expenses. Every time they submit a reimbursement, it gets put into a form that includes their name, clock ID, date,…