-
IfError Formula
Hello, I have the formula but would like to add the IfError to it to avoid the #DIVIDE BY ZERO - any suggestions? =[2018/2019 Sales]1 / [Square Feet]1
-
Sheet Summary COUNTIF
I'm having problems using the COUNTIF function in the new-ish sheet summary. Everytime I sort rows it changes the range. For example, in a summary text field I have =COUNTIF([Column A]1:[Column A]79, =0) After sorting by a column it becomes =COUNTIF([Column A]29:[Column A]43, =0). Or something similar. The sheet summary is…
-
#NO MATCH when counting the results of a VLOOKUP
I am trying to count how many items fit 2 criteria, one is the year, the other is the state. The issue is coming in with the state, as I just changed it to a VLOOKUP and my formulas were all working before I did that. The VLOOKUP is working, but there are a few values which return a #NO MATCH and I can't change that due to…
-
Feature Request: timestamp() function
It would be great if there was a way to timestamp the value of a cell. To enter the exact date that an event occurred. Several people have volunteered a modified date column, but something like the following functionality in an if-statement would be really great. =IF(FieldName1 = "blah", timestamp())
-
=IF(AND formula returning "invalid Operation" error
I have several check box columns. When all are checked, I want to turn on a flag in another cell. I first tried testing two of five check box fields and Smartsheet returns "invalid operation" =IF(AND(COI:COI = "1", EFT:EFT = "1"), "1") What am I doing wrong?
-
Method/formula to rename sheets, reports and dashboards in a folder
Have a folder with 15 sheets, reports and dashboards used as a template folder. Titles include (Clear) as a generic placeholder in the folder and used in the 15. When a new project is started, we "Save As New" that folder, replace (Clear), with the project folder name and do so for each associated sheet, report and…
-
INDEX/MATCH Formula Help
Hello! I'm creating a document where I would like to index a column of dates, and return a specific date from that list. I need one of two things to occur: 1) If a date occurs in the upcoming week, I would like to return the latest date of the week 2) If no date occurs in the upcoming week, I would like to return the…
-
Formula Function - SMALL for dates with duplicates (ERROR)
Hi, I'm currently using a formula to INDEX my sheet and pick up the smallest date in a column, and then display the 4 smallest (or soonest) dates in that column to pull into my dashboard. The formula is as follows: =INDEX([Project Name]:[Status], MATCH(SMALL([Next Milestone Date]:[Next Milestone Date], 2), [Next Milestone…
-
Struggling with IF(AND....to return a checkbox
Can't seem to get this formula to return a checked checkbox =IF(AND([Total cartons]@row > 5000, [Container Type]@row = "Cart",[Load Status]@row="Complete”),1,0) any suggestions
-
Consolidating Data from Multiple Sheets
Hello, I'm hoping there's an easy way to do this. I have three sheets, they all are filled in using forms. All three sheets are used for tracking things to be billed to the same list of clients. This client list is identical between all three sheets, if it matters. I'd like a single sheet I can look at each month that will…