-
Can I set a cell equal to all data from a column of another sheet?
I want to pull a whole column of data from Sheet1 into a single cell on sheet2. The name of the column on sheet 1 is "Emails". I can't get a formula to work. cell formula something like ={Sheet1!Emails}? I am pretty new to Smartsheet formulas.
-
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…
-
Add function to retrieve values from cell for a multi-select column
Like the COUNTM which gives the count of values in a multi-select cell, it would be great if there is any function or combination of functions that can provide an array/list of values from a cell so that any particular value can be compared/matched/processed.
-
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…
