-
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…
-
Delete a Sent Update Request
Since Smartsheet doesn't have the option to resend update requests that haven't been completed, I wrote a script to pull all sent update requests, filter on pending requests, generate+send new requests, and delete the original request. The problem I'm having is that the delete update request call fails every time. It fails…
-
Bug/Error? Report widget on dashboard doesn't link to specific row
I created a report that includes the "Sheet Name" column. The auto-generated links in this column go directly to the specific row on the sheet it's linking to. However, when I add the report as a widget on a dashboard, the links open up the sheet but they don't go to the specific rows. Seems like a bug/error. This happens…
-
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…
-
Is there a way to search only within a specific column in a sheet?
It would be helpful to be able to filter a search to only look at a specific column in a sheet. Sometimes I know what column the info I am looking for is in but I am only able to search the whole sheet where there might be more than one instance of that information (but in the wrong column). Also, since the search results…
-
Link Data in a Smartsheet on a Specific Day and Make Static
I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to create a new Smartsheet that links data from the %Complete metric on a given day, and make that data static in the new…
