-
Index match or collect
HI Experts, I try to set up a formula for below table. Blue Part is on another sheet, and I would like to show the correct awbif article is the same and "Name" is "Kerstin" in the yellow marked column "awb new sheet". I tried a few versions with Index and Match or collect, but without success. Would be great if you could…
-
Count if (Advanced) Contact Field
I am having trouble counting the number of contact or lack of in two different instances. Count Assigned to Business Count non-blank contacts (exclude those that contain the word "business") First Metric: I would like to count the number of times my contact field has the word "Business" in it. I've tried the formula below…
-
24 hour countdown
Does anyone know how to create a 24 hours countdown based on the created column? We need to trigger a notification or update request on a flag 24 hours after the row was created. We work in time zone globally and need to give the team 24 hours to complete their update request. Thank you in advance. Joe
-
Function assistance
I have a sheet that has a date column (Sent for Customer Signature Date) and a checkbox column. I am using this formula "=IF([Sent for Countersignature]@row, "0", TODAY() - [Sent for Signature Date]@row)" (this is a column formula) to calculate how many days we are waiting for the customer signature to come back. When I…
-
Creating Report Workflow Automation that goes out on the 3rd Friday following a Monday
Basically, I can only use weeks where there is a Monday in that month before the 3rd Friday. So the native function of picking 3rd Friday will not work for this scenario. I have seen lots of help for Monday's but am not sure how to program this one. I need to send out a report reminder to owners the 3rd Friday following a…
-
How to if statement for more than one cell ?
How to if statement for more than one cell ? What I have is three cells with dates and I want the sheet to check if there is a date in the 3rd cell to count from that date if not to check the second and if not to check the first cell
-
Using the ,21 (ISO) option when determining WEEKNUMBER - Sheet displays ok, Report doesn't
Hi, When using this formula to return a week number =IF([Date completed]@row = "", "", WEEKNUMBER([Date completed]@row, 21)) the correct week number value displays accurately in the sheet which is good. However, the Report fails to display the column value and displays #INCORRECT ARGUMENT SET Removing the ,21 parameter and…
-
Blue ball if 100 %
I designed a sheet in which a 100 % progress (available in a dropdown menu) should be automatically turn blue in another column I tried to use an if formula but it is UNPARSEABLE =IF(Fortschritt@row = "100%" ; "Blau") What am I missing? Thx for help!
-
COUNTIFS not working
Hello, I have attempted to COUNTIFS from one smartsheet to another, however I have had no luck. Once smartsheet is being used to collect numbers and the other is getting information pulled in from Jira. As you can see in the screenshots I am trying to count certain words in text fields and not a matching character in a…
-
Countif for multiple selection column
Hi I'm trying to find a formula that will count a particular option in a multiple select column on another sheet. I've tried using CONTAIN, HAS and FIND but neither appear to work - I get an error or it just returns a zero, when I'm expecting 1. Any help would be greatly appreciated. TIA Cheryl