-
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…
-
Calculating a minimum payment figure using a formula or function
Hello, I'm hoping someone may be able to help me with something that probably seems quite obvious or basic however, my knowledge on formulas or functions within Smartsheet is not advanced, so I apologise in advance! I'm trying to get my finances in order and thought I'd use Smartsheet to plan this. I've done a screen shot…
-
Count average time to close action
Hey, Can anybody please suggest me with a formula that would calculate the average time a person takes to close an action assigned to him in a row? I have attached below the layout of the sheet. The formula should calculate the start of the time from when the date raised changes to a value and return a value in the time…
-
Formula to reference another sheet
Hello, I need to make a formula for the following and appear to be missing something or doing it wrong. If the Date Field is filled in, then i want the Project Manager field to fill out based on a cell in another sheet. I have the first part of =IF(Date@row >0