-
Index Match help
I am trying to convert from Excel to Smartsheet without adding a ton of columns to make this work. I am not if Index/Match is the way to go OR VLOOKUP, etc. Again, the entries from the operators will vary therefore the low/high specs are used in previous columns that you helped me with. This is the excel version of ONE…
-
Help with Cross Sheet JOIN(COLLECT) formula
I've built a formula to complete a JOIN(COLLECT). If I put the formula on the same sheet as my column references it works just fine, however when I move this to a separate sheet and update the column references to the other sheet I get the error #UNPARSEABLE. From what I can tell I haven't removed any of the formula…
-
Validate Column Data Received in a Form
I have created a simple form to collect the following fields of data: First Name Last Name Email ID number Because a lot of times people are entering information into a form from a mobile device and sometimes have "fat fingers," I wanted to validate the ID column (with a list of users and IDs on another smartsheet). What…
-
Question on Counting days "If"
Hello, In my Smartsheet I have a status column that = "RESOLVED" or "IN PROGRESS" Each row has an "ENTRY" date and sometimes a "RESOLVED" date, if applicable. If a row is "IN PROGRESS" I want it to count the NETDAYS from today, but... If an row is marked "RESOLVED" I would like the NETDAYS function to stop counting.…
-
Nested IF Help
Hello, I have these columns: In a perfect world, when the status changes to RESOLVED, the date resolved would automatically populate. Since I can't do that without the use of something like Zapier, I'm trying to define a workaround using an additional column "Days to Resolve". Some issues have been resolved, but a…
-
RYGB symbols automated to reflect status/progress
Hi there, Attempting to write formula to automate RYGB symbols when task is In Progress, On Hold or Complete. I've prepared a few formulas and none seem to be accurate. If someone would take a look at below attempts and let me know what needs to be changed, I'd greatly appreciate it! None of below worked: =IF(OR([Status]6…
-
=SUMIF Month-to-Month
I am trying to create a graph for a Dashboard that will display the total amount of approved $$ within each month and total amount of denied $$ within each month. I will also need a rolling YTD total. So far this is what I have for the formula: =SUMIFS({RSA Form Range 2}, {RSA Form Range 9}, "Green", {RSA Form Range 3},…
-
Count Children formula
I have this formula that is working properly except I need to adjust it. Basically what this formula is doing is counting the children rows if a specific date column has nothing (is blank). However, what I need to also adjust for is to have my formula return a "zero (0)" if the units have expired (captured in a helper…
-
Countifs error
Hello, I am trying to count the number of occurrences when column1 = value1 AND in the rows that have a check box in column2. Can anyone see why this formula is #Unparseable? When tested individually, the formulas work but together I get an error. =COUNTIFS([column 1]:[column 1], "value 1”, [column 2]:[column 2], "1")…
-
Multi-Layer Formula for COUNTIFS and IF
Hello, I am trying to see the number of employees that called off for each shift for yesterday only. This is what I have so far. I want to see the number of employees that called off on "Shift A" and that call off is "Unscheduled" , but ONLY want to see any calls with the call-off date that was yesterday. Do I need an…