-
Capacity formula
I am trying to add to this formula "<+" &{end week}, Weekend@row =COUNTIFS({Name}, [Primary Column]@row, {Week}, start@row, {Year}, [Column3]@row, {SKill}, "LTE") * 60 I want this formula to look and see the end week and add 60 for every week of the project. Help columns and example below. Right now this formula tracks 60…
-
Drop Down Multi Select Formula
Good afternoon everyone. I am trying to figure out the best way to build an "IF" type formula from a multi select column. The formula I tried was: =IF([1. Line of Coverage]@row = "Voluntary Life/ADD", 1, 0). This would put a star in a column to illustrate that a document needs to be collected. This works as long as only…
-
COUNTIF Date Range with criteria
I am trying to count when Brian shows up in column "Auditor Name" but only for a specific week, dating 6/3 - 6/7. =COUNTIFS({Audit Date}, >=DATE(2024, 6, 3), DATE(2024, 6, 7), AND({Auditor Name}, "Brian Lucas"))) Where is this going wrong?
-
Formula Auditing/Evaluation
How do you audit or evaluate a formula in smartsheet? In MS Excel, you can audit/evaluate a formula to see the calculations for each step of the formula. I can't see a way to do this in smartsheet. I have a simple formula that should be giving me a specific value, but it's not, and I can't figure out why since I can't…
-
What formula will identify duplicates in a column and only keep the most recent row?
Hi there! Our staff fill out an "availability" form which populates a sheet with their availability for the week. I'm trying to create a formula for this sheet that will identify when a person has submitted their updated availability, and remove/hide their previous submissions. I assume the way to do this would be…
-
Date Comparison Unexpected result
Option 1: =IF(([Last_Updated_Date]@row - $[Last_Updated_Date]$1) < 0, "Up to date", "Please Update Before Proceeding") Option 2: =IF([Last_Updated_Date]@row < $[Last_Updated_Date]$1, "Up to date", "Please Update Before Proceeding") I am writing the result in a column name Template_Updated which is Text/Number Column data…
-
Counting event between 2 dates
Hi, I would like to know on my sheet summary, how many clients got registered between two dates, ex: between November 1rst and November 30th. My dates are entered in this format DD-MM-YYYY. Thank you for your help
-
locking row to the top
I have a sheet that gets filled with data from a form, is there a way I can lock the top row so when the form is filled the new row appears below the top row. I have the row locked but new rows from the form always appear above it. Just having the row appear at the bottom wont work for me as I want formulas in the top…
-
Using COUNTIFS with CONTAINS
Hello, I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this: =COUNTIF(CONTAINS("Bernie Sanders", [Assigned]:[Assigned]), "True") The return value that I get is "0," which…
-
If Then with a Index Match
Hi, I'm having an issue where I cant put an index match as a result of an if statement. when I just have the index match in the cell, it does the action, but when i have the if then statement, it says the invalid operation. Am I just missing something in the formula? I am planning on making this a pretty long chain of if…
