-
The dreaded #INVALID DATA TYPE error
I created what I thought was a simple nested IF statement, but got hit with an #INVALID DATA TYPE error. Both columns have the Column Type = Text/Number All "State" fields are populated with valid 2 character US state abbreviations. What am I missing? Formula: =IF(OR(State@row, "AL", State@row, "KS", State@row, "MI",…
-
Lookup and Return newest Date
Hi there, looking for assistance i am trying to create a formula I want to reference a second Sheet called "Medical/Lost Time" Id like it to look up the Shift entered in the Shift column and return the newest Date from the Injury Date column I've created a Data Sheet with the Reference names for the shifts ([Primary…
-
Countifs with distinct on four column from another worksheet
Hello Everone, I tried to post this before, but it was probably the wrong way. I am new on the community, though I have been using Smartsheet for few years, (I am French, maybe my English will be different than yours sorry about that). I came here to look for an answer to my problem. I am trying to use the Distinct…
-
Simple Automation Not Working
Hi all. I have a simple automation set up to trigger when a station number is change/updated/add in my master sheet to copy to another sheet. It isn't working at all. If I change the station # to another station it isn't updating the separate sheet and if I change it back to the original station # it isn't coping the whole…
-
copy text from one cell to another in one sheet
Hi, solution seems to be simple ;-) I want to show text that I choose from a dropdown field in another cell in the same sheet. [column one] [column two] [column three] before choosing [blank] [options 1-5] [options 6-10] after choosing [ =text no. 7 ] [options 1-5] [chosen option 7] what kind of fomula do I have to enter…
-
Formula help for graphs with data that "contains"....
How do I make a graph with data set from a list of dates that is greater than 12/31/21, less than 01/01/21, and then between )1/01/21-12/31/21, from a list such as this 07/29/22 12/31/20 01/29/21? I know the contains formula but this is to capture all dates prior to 2021, during 2021, and after 2021?
-
Way to tell a report to include the parent row info for child tasks?
I'm creating a report to display all tasks assigned to certain users, but it's difficult to tell what some of the child tasks are when divorced from their parent task. Is there an easy way to tell the report to also pull in the parent row info.?
-
COUNTIFS with AND/OR
I'm trying to get a COUNTIFS where it's got an OR of two different sheet references. Its the OR that's causing me issues. I can get an OR @CELL formula that will work for different values in a single column, but not two different columns. The formula is essentially: =COUNTIFS({Approval State07}, "closed", {Status07},…
-
Time Keep Formula
Hi There Hoping you can help me out with this one. I'm trying to create a Time Keeping Register for my Company. I have created a Unique ID card with a QR code. I have created a spreadsheet for each Project, where they can scan the QR code onto Smartsheets with a date & time stamp. See below Screen Shot. Now comes the hard…
-
Invalid Value for Index/Match
Hello, I found an earlier post regarding indexing with duplicate values in the lookup column (List) and managed to get the results few weeks ago but now it's showing Invalid Value (after I have removed IFERROR). I can't seem to find the post anymore. Any idea why the formula is not working?
