-
How do I get the sum of total hours worked on this project?
-
IF statement using INDEX/COLLECT
Hello! I am looking to write an IF statement referencing 2 different sheets saying "IF the value is not found on sheet 1, look for it on sheet 2." I am also looking to pull in the most recent entry on my reference sheets. =IF(INDEX(COLLECT({range 1, SLCA}, {criteria 1 SLCA, equipment number}, [equipment number]@row), 1),…
-
Counting options selected in Multi-Select Column
Is there a way to count the number of options selected in a multi-select column in another column? Column3 here has the result we are looking for.
-
COUNTIFS for multiple columns to include date parameters
Hi, I am new to smartsheet and still learning. I am working on a dashboard and trying to create a metric sheet so that I can plug in data to my dashboard. I am trying to calculate: How many events (wedding, bachelor party, bachelorette party) occurred in individual states (TN, MS, SC) month on end? I have tried multiple…
-
MONTH function returning #INVALID DATA TYPE because it is blank
How can I use the MONTH function if the cell is blank? It is returning #INVALID DATA TYPE. I'm pulling this information into 3 columns from the Actual Submission Date Column: "Month" - new column with the following formula: =MONTH(([Actual Submission Date]@row)) "Year" - new column with the following formula: =YEAR([Actual…
-
Is there a function to find a Max or Min for text?
I know I can do this with a helper column, but I'm trying to avoid that since this sheet copies to a bunch of others and I don't want to have to go and hide the column in all of the downstream sheets. I have a ID column that consists of alpha and numeric (ex. ENV-032) in sheet A. When someone fills out a form to add a new…
-
COUNTIF With Parameters in Two Columns
I am trying to create a formula that will count the number of status of 24-72 for the month of Oct 22. I have tried a number of iterations without success. Example formula tried (yields unparseable) =COUNTIFS([Month Year]:[Month Year], "Oct 22", [Status:Status], "24-72") Sheet info
-
Help with Date Formula
I need help with this formula, please. I need to get the PO date from this sheet and output that date to this sheet I tried this formula but it is not working: =IFERROR(INDEX({PO Date}, MATCH([Vendor Name]@row, {Vendor ID#}, 1)), "") Both columns are Date fields Thank you!😀
-
VLOOKUP via another Smartsheet not working..
Hi All, Noob here.. Im trying to perform a VLOOKUP via a second smartsheet, but I keep geting the error "#INCORRECT ARGUEMENT SET", I cant see what I'm doing wrong, can you help please? This is smartsheet 1 and my formula that I want to populate from smartsheet 2: This is smartsheet 2, where I want to pull data from: This…
-
Formula help - COUNTIF consecutive dates
We use a smartsheet form for staff call outs. We've implemented a point system for disciplinary action. A call out or absence is 1 point, a tardy is 1/2 point. I've worked out the math to count the point value of the row -0 if "excused" is checked. However, consecutive days if calling out sick are considered one absence. I…
