-
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…
-
Logic formula for checkbox
I am trying to get a box checked if a completion date has been entered OR a status has been marked complete. Formula I have is =IF (Status3 = "Complete") OR NOT(ISBLANK([Real Completion Date]3)),1 What am I doing wrong here?
-
Countifs with special requirement
Hi, I need to use countifs to count the number of calls made to customers today. In my example, Touch 1 and Touch 2 are calls today, however I also need some filtering with user input. The criteria are as follow: Date equals to "Free Text Date" of 20/04/2020 (X1) Salesman equals to "Free Text Salesman" Peter (X2) Only…