-
Use of IF AND OR ISBLANK
I would like to write a statement that writes Pending if true and Complete if false. The criteria for Pending are as follows: If start date > today, and end date > today or end date is blank (where Start Date and End Date are columns) Here is the statement I wrote, but I keep getting Incorrect Argument Set. =IF(AND([Start…
-
Assigning a count to each dropdown category
Hi, Recently with the help of this community and customer support, I have created this reference table of categories and sub-categories (see screenshot 1): However, I would like to also track the amount of times the sub-categories are entered. Say for example, A was found 5 times. In the dropdown menu from the solution,…
-
Problem with INVALID DATA TYPE error with COUNTIF formula
Hello, I am trying to capture all entries where my delay (calculated using NETDAYS formula) is bigger than 50, using COUNTIF, and getting an INVALID DATA TYPE error. I tried many things, including making sure the dates used to calculate the delay ARE proper dates. I am stuck. The strangest thing is I used to had this…
-
Setting up an Average Filter across multiple columns
Hello All I'm new to Smartsheet's and still learning formula. So hoping someone can help with this for me as I'm struggling to figure out what I'm doing wrong? I require a sheet that will give me the average number of hours an organizer has spent on a completed project per given month See above When creating the formula I…
-
Cell linking
Hey, I want to link values from one sheet to another, but to keep 3 empty rows everytime between the linked cells. Is there a way to do that? Thank you very much
-
Combine data from parent/child rows into a single row
Hi, I would like to pull data from parent and child rows into a single row. I only want to display specific columns, so have been trying to do this using a report. In the first column, I want to display the data from the parent cell. The other columns would have data from the child cells. What I currently have is this:…
-
Looking for the most recent date
Hi there, We have a internal learning courses that people can do to earn 'badges', there is approx 14 badges, each badge has around 5 units that need to be completed. When a unit is completed the person fills out a form which goes into a smartsheet to then be sent to an approver (once approved info gets sent to sheets for…
-
Trying to average values from one column based on conditions of two other columns.
Where I have Columns "Employee Name", "Score Week", and "Week Score" I want to average the "Week Score" for the "Employee Name" where "Week Score" is a value of "1", "2", "3", or "4". I started here: =AVG(COLLECT([Week Score]:[Week Score], [Employee Name]:[Employee Name], [Employee Name]@row, [Score Week]:[Score Week],…
-
Pulling Purchase price from a master sheet
Hey All, I have a master sheet where I input items that I purchased and it's price. To identify a product I use SKU's for each Product. Now every two weeks I pull my sales and import it to a new smart sheet. The I copy the sku and go into my master sheet and find it there and look at how much I paid for it, then I got back…
-
How to display a MIN date on parent row when all children date rows contain a formula
I have a date column (Start Date) which is being populated from a Vlookup which references a separate calendar table. For the Parent Rows of the populated date column (Start Date), I would like to display the minimum date of its children. Formula used in the Parent cell: =MIN(children()) Result: no error is thrown, but no…
