-
Index and Match function is not working
Hi Team, Am trying to create a sheet using Index and Match function and am able to fix the issue.
-
Using Countifs with Cells Containing Multiple Values
I am trying to setup a formula that counts how many times a certain option is selected from a dropdown list. In this dropdown you are able to make multiple selections. And this is where I am having Issues. I was able to use: =COUNTIFS({Drop Down List}, Option@row, {Week}, Week$2) to count how many times the option is…
-
Using automations to add to a cell.
Is there a way to use an automation to add a number to a cell? What I am trying to do is have 24 add to a cell at the beginning of every year. So that it is a running total. (Year one they have 24, next year it adds 24 more, 48, next year its 72, and so on, it just keeps adding 24 on jan 1.) This is for my companies sick…
-
Formula: percentage based on dates
This discussion was created from comments split from: Am I able to create a formula that will advance the percentage complete based on start and End Date?.
-
Hi, I would love some help smoothing out my whatif formula around task health
I am on a complex software development program with multiple releases being managed. I've created reports, summary sheets, and dasboards to manage this. Typically im fine with the formulas but this one has stumped me for more than 6 hours in total so i wanted to run it by this team of experts. I need to run a task summary…
-
Parent and Child Formula
Is there a formula that can support a parent cell updating to the symbol that matches the last sequenced child that is filled in?
-
Unparseable Error
Hi, I would like to add a health status formula but i am receiving an error. =IF(Status@row = "Not started", "Blue", IF(Status@row="In Progress", "Yellow", IF(AND(TODAY() > [end date]@row, Status@row="In Progress"), "Red", IF(Status@row="Complete", "Green")))) Any help would be greatly appreciated.
-
"CountIF" issues
Hi everyone. I am trying to get Smartsheet to run a basic COUNTIF function, and it's finding #NO MATCH. The formula is: =COUNTIF([PE Manager]:[PE Manager], CONTAINS("Anna Richey", @cell)), where I am trying to count all instances of the name "Anna Richey" showing up in the [PE Manager] column. Any ideas what I'm doing…
-
Combine data from multiple columns, unless data is the same
Hello Smartsheet Community! We have (2) sets of columns of data that pull in data from (2) other sheets for Ship Dates, Tracking, Order Numbers, etc. Sometimes both sets of columns will be populated sometimes just one column will be populated. We are currently using the JOIN function to combine the data from a set of (2)…
-
How to link cells from a form to automatically update in a separate sheet??
I am trying to link a couple of cells from a recruitment request form into a separate candidate tracker sheet. I am using the form template to keep track of recruitment requests and a task shee to keep track of candidate procedures. I was envisioning the candidate tracking sheet automatically updating when a recruitment…