-
Excluding Weekends from Date formulas?
Hi, I'm hoping this is possible and someone can guide me, but I am trying to automatically exclude weekends from date formulas. In my sheet I have a duration column (which is calculated based on a number of other columns: task performed, difficulty level of task, etc) and then a start/end date column which calculates on…
-
SUMIF with a checkbox
I'm trying to sum a row of amounts (Parking Revenue Regular:Private boat parking revenue) into the column "Total Parking Revenue", but only if the checkbox "Payment Voucher" isn't checked. When I add the rows using this formula without the checkbox, it works (formula on first row only): =SUM([Parking Revenue…
-
URL Query String and Workapps
Hi, I created URL query string to pre-populate values a form for 12 different departments (to ensure each selects their correct area). I followed the instructions from Use a URL query string to prefill different default values for the same form | Smartsheet Learning Center. Then I tested each URL strings to ensure the…
-
IF formula help please
I have one column that has a drop down of 3 choices and based on the answer I want to list information in another column. Like if they select "Submitter of this form" I want it to return the information in the "Submitters email" column. Getting an error and can't see what it is; =IF([Site specifics]@row, = “Submitter of…
-
Can you use a COUNTIF formula to county symbols?
I have a list of goals for the year and we are using harvey ball symbols to indicate the percent complete an the red, yellow, green, gray balls to indicate the health/status of the project. I would like to display a report on my dashboard that shows the number of projects we have in each harvey ball stage and also in each…
-
Check a box if values appear on two sheets
Hi, I'm trying to check a box if a Sales Force ID on my source sheet appears on another sheet This is the formula I'm using but am getting an "Invalid Operation" error. =IF({Sales Force ID} = SalesForceID@row, 1) Thanks!
-
Delinquency Report
Hi SmartSheet Community, How do you pull a delinquency report showing month to month stagnation, in the same column across sheets? I'd like to send a monthly update request form for the "assign to" with their lists and pull only those item's whose %complete hasn't been updated in the last 30days. Is there a column specific…
-
Issues With Extra Commas When Joining Values of Multiple Columns Into One
Hello, I am using the following formula to take values within multiple columns into one column: =IF(ISBLANK([Automation (Corelab)]@row), "", [Automation (Corelab)]@row + ", ") + IF(ISBLANK([Cardiometabolic (Corelab)]@row), "", [Cardiometabolic (Corelab)]@row + ", ") + IF(ISBLANK([Coagulation, Hematology, Urinanalysis…
-
Formula Help
I am for some reason having an issue getting function to calculate correctly. I need to pull the count for just active projects in one column but it is calculating all of them. There should only be 143. Can anyone help with this? =SUMIF([Project Phase]:[Project Phase], "Active") =COUNTIF([Project Phase]:[Project Phase],…
-
How do I create this function using COUNTIFS?
I am trying to create a function that calculates: % of Urgent Intakes Completed Within Two Business Days (Starting 4/1/23) I have tried the following: =COUNTIFS({Start Date}, >DATE(2023, 4, 1), {Priority}, "Urgent", {Finish Date}, "<=WORKDAY([[{Intake Dates}]],2)") / COUNTIFS({Start Date}, >DATE(2023, 4, 1), {Priority},…