-
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
-
I need to determine if a date column is blank then it returns a message
Hello, I want help with a formula to return a message that says met goal if the date is blank or did not meet if the date is populated. I tried this formula but it is not working it returns #Unparseable =IF(ISDATE([Request Intake Range 9]1:[Request Intake Range 9]22), "met goal", "did not meet") So essentially I want to…
-
Profit percentage calculation
Hey all. Trying to get a profit percentage formula. Columns are: "Price Bought" "Price Sold" I want to get the profit between the bought and sold, so if I bought for $1200 and sold for $1000, that's 20% profit ($1200 / $1000 = 1.2) What's the correct way to do this?
-
Worksheet population with Formulas
I have a spreadsheet populated by a form where one field needs to be populated using a JOIN of multiple fields from the spreadsheet which are populated using from entry and another needs to be populated by a VLOOKUP. I've tried assigning the formulas to the blank rows ahead of time and using the Change Cell Value workflow…