-
Formula Question
Hello, I have a scenario where I want to build in an If AND formula and just am not too familiar with how to set it up. I want to set it up as follow: If someone's age is >= 55 AND their tenure is >=10, I want the column to state yes. If it does not meet this criteria, I would like it to say No. Could someone help me set…
-
Increment previous row by 1 using column formula (when condition is met)
Hello Smartsheet Community, Looking for what should be a simple solution here: ultimately need to increment count by +1 once a new Project name is entered in a new row. If there are 8 Items within a Project, they will carry the same Project Count value, until a new Project is entered, after which Project Count increases…
-
Count when 2 Conditions are met
I have a field called Status & a field call Health (using RYG symbols) This =COUNTIF(Health:Health,"Green") counts the symbols correctly. But I am trying to count Status "Open" that have a Health "Green". So I tried using COUNTIFS… =COUNTIFS([Health:Health],"Green",[Status:Status],”Open”) Gives #UNPARSEABLE 😕 Can anyone…
-
COUNTIFS Status and Year is Current(Cross-Sheet Formula)
Hello Community… Stuck trying to work out a COUNTIFS formula for Status is X and Year from a date column is current year, The first part I have… =COUNTIFS({Status}, "Pending Submission", The second part I am looking for help in this the {Submission Date} which is currently a date column is the current YEAR. I have this…
-
INDEX/MATCH Question
I need to do an index/match formula within the same sheet, but it is returning a UNPARSEABLE error. The columns in the sheet are as seen below: We're listing the parent unique ID and we want to find the parent unique ID across the sheet so that we can find from a different column what the $ amount of savings is. Please…
-
This Month's/Year's Net Work Days As Of TODAY
So, August 2024 has 22 Net Work Days. But as of today (08/07/2024), there are only 18 Net Work Days remaining in August. Is there a formula I can create that will show me "X Month's/X Year's" remaining work days? So the August 2024 answer would be 18 as of today, September 2024 would be all 20 remaining work days, October…
-
Formula that returns the title of any Issue Links in a Smartsheet linked to Jira project
Hello! I have a sheet that is linked to a Jira project, and for Bug tickets, I'd like to see the titles of the blocked issues. Typically, I would use an INDEX/MATCH formula, but I'm not sure of the best way to isolate the issue key(s) from the Issue Links field so I can use it as the lookup value. In some cases, a Bug…
-
How to capture the Name of the person who changes the column value?
Hi all, I'm trying to to capture the name of the person who does the final change in a material release in a process. Please see attached. The goal is to have the name of the person who clicks release (which is the final progress status). Do I need a formula for this? I used created by option in the sheet. Not sure if…
-
Need Help With Tricky Formulas
For my projects (one per "column"), I have a column for "Deadline", "Remaining Hours", and "Networking Days Between Today and Deadline". Then there are columns that need formulas that need to calculate "splitting all remaining hours" evenly across months up to the deadline (and a column for August 2024, September 2024,…
-
Are the SUMIFS formulas working properly?
This formula worked yesterday in my sheet summary field and today is not working.. =SUMIFS([Remaining Work]:[Remaining Work], Category:Category, OR(@cell = "FC Support", @cell = "Maintenance & Reliability", @cell = "HR", @cell = "Chewy Leadership Academy", @cell = "FC Operations", @cell = "FC Systems", @cell = "Supply…